#!/bin/bash
source ../../config.sh

#助学金信息（2017-2018）
function financial_aid_info_2017(){

    HIVE_DB=raw
    HIVE_TABLE=excel_financial_aid_info_2017
    delete_table


    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
          id STRING COMMENT '序号',
          name STRING COMMENT '姓名',
          id_card STRING COMMENT '身份证号',
          degree STRING COMMENT '学历',
          department_name STRING COMMENT '院系',
          major_name STRING COMMENT '专业',
          student_no STRING COMMENT '学号',
          sex STRING COMMENT '性别',
          HKLX STRING COMMENT '户口类别',
          native_place STRING COMMENT '生源省份',
          type STRING COMMENT '贫困程度',
          amount STRING COMMENT '获助金额(元)',
          family STRING COMMENT '建档立卡家庭学生类别'
      )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

    fn_log "create table ${HIVE_TABLE}"

    load_data financial_aid_info_2017.csv

}


#助学金信息（2016-2017）
function financial_aid_info_2016(){

    HIVE_DB=raw
    HIVE_TABLE=excel_financial_aid_info_2016
    delete_table


    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
          id STRING COMMENT '序号',
          name STRING COMMENT '姓名',
          id_card STRING COMMENT '身份证号',
          degree STRING COMMENT '学历',
          department_name STRING COMMENT '院系',
          major_name STRING COMMENT '专业',
          student_no STRING COMMENT '学号',
          sex STRING COMMENT '性别',
          HKLX STRING COMMENT '户口类别',
          native_place STRING COMMENT '生源省份',
          type STRING COMMENT '贫困程度',
          amount STRING COMMENT '获助金额(元)',
          is_card STRING COMMENT '是否建档立卡'
      )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

    fn_log "create table ${HIVE_TABLE}"

    load_data financial_aid_info_2016.csv

}

#贷款信息
function loan_info(){

    HIVE_DB=raw
    HIVE_TABLE=excel_loan_info
    delete_table

    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
          id STRING COMMENT '序号',
          xxsm STRING COMMENT '学生姓名',
          xfzh STRING COMMENT '身份证号',
          dkcs STRING COMMENT '贷款次数',
          szzzx STRING COMMENT '省资助中心',
          xzzzx STRING COMMENT '县资助中心',
          gxmc STRING COMMENT '高校名称',
          gxlb STRING COMMENT '高校类别',
          jdlx STRING COMMENT '就读类型',
          xz STRING COMMENT '学制',
          rxnf STRING COMMENT '入学年份',
          byrq STRING COMMENT '毕业日期',
          yx STRING COMMENT '院系',
          zy STRING COMMENT '专业',
          xh STRING COMMENT '学号',
          htbh STRING COMMENT '合同编号',
          htzt STRING COMMENT '合同状态',
          htje STRING COMMENT '合同金额',
          dljg STRING COMMENT '代理机构',
          dljswd STRING COMMENT '代理结算网点',
          grzh STRING COMMENT '个人账号',
          dkqx STRING COMMENT '贷款期限',
          kfrq STRING COMMENT '发放日期',
          dqrq STRING COMMENT '到期日期',
          qjfyze STRING COMMENT '欠缴费用总额',
          xxmc STRING COMMENT '高校名称',
          gxsfkhh STRING COMMENT '高校收费开户行',
          gxsfkhwd STRING COMMENT '高校收费开户网点',
          gxsfzhm STRING COMMENT '学校收费账户名',
          xxsfzh STRING COMMENT '学校收费账号',
          xxlxr STRING COMMENT '学校联系人',
          xxll STRING COMMENT '学校联系'
      )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

    fn_log "create table ${HIVE_TABLE}"

    load_data  loan_info.csv
}

#学生勤工助学记录
function load_work_study_info(){

    HIVE_DB=raw
    HIVE_TABLE=load_work_study_info
    delete_table


    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
          id String comment '序号',
          student_name string comment '学生姓名',
          class_name string comment '学生班级',
          id_card string comment '身份证号',
          number string comment '我也不知道这个是什么',
          money string comment '补助金额',
          teacher_name string comment '指导老师名称',
          start_time string comment '勤工俭学开始日期'
      )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

    fn_log "create table ${HIVE_TABLE}"

        load_data    2017-01.csv
        load_data    2017-04.csv
        load_data    2017-05.csv
        load_data    2017-06.csv
        load_data    2017-11.csv
        load_data    2018-01.csv
        load_data    2018-04.csv
}

#学生宿舍通报记录
function circulate_info_info(){
    HIVE_DB=raw
    HIVE_TABLE=circulate_info_info
    delete_table

    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
          circulate_time string comment '通报日期',
          apartment_no string comment '公寓号',
          class_name string comment '班级名称',
          dirty_info string comment '卫生脏乱差',
          smoking_info string comment '宿舍抽烟',
          unlock_info string comment '没有锁门',
          big_electric string comment '大功率电器',
          night_out string comment '夜不归宿',
          other_warning string comment '其他安全隐患',
          this_week_comment string comment '本周违纪情况说明',
          place string comment '校区名称',
          department_name string comment '系别名称'
      )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

    fn_log "create table ${HIVE_TABLE}"

    variable=(
    01.csv
    02.csv
    03.csv
    04.csv
    05.csv
    06.csv
    07.csv
    08.csv
    09.csv
    10.csv
    11.csv
    12.csv
    13.csv
    14.csv
    15.csv
    16.csv
    17.csv
    18.csv
    19.csv
    20.csv
    21.csv
    22.csv
    23.csv
    24.csv
    )
    for i in ${variable[@]}; do
    load_data ${i}
    done
}

#学生勤工助学对应岗位
function load_work_location_info(){

    HIVE_DB=raw
    HIVE_TABLE=load_work_location_info
    delete_table


    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
          id String comment '序号',
          location_name string comment '岗位名称',
          teacher_name string comment '指导老师名称'
      )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

    fn_log "create table ${HIVE_TABLE}"

    load_data work_list.csv
}

#省份表
function load_province_info(){
    HIVE_DB=raw
    HIVE_TABLE=load_province_info
    delete_table

    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
          number String comment '省份编号',
          province_name string comment '省份名称'
      )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

    fn_log "create table ${HIVE_TABLE}"

    load_data province.csv

}

#县级表
function load_county(){
    HIVE_DB=raw
    HIVE_TABLE=county_info
    delete_table

    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
          id string comment '县级编号',
          name string comment '名称'
      )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

    fn_log "create table ${HIVE_TABLE}"

    load_data county.csv
}


#专业录取学生信息表
function load_admissions_info(){

    HIVE_DB=raw
    HIVE_TABLE=load_admissions_info
    delete_table


    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
                major_no STRING COMMENT '专业编号',
                major_name STRING COMMENT '专业名称',
                educational_system STRING COMMENT '学年制三年3五年5',
                grade_name STRING COMMENT '年级',
                report_number STRING COMMENT '报到人数',
                actual_admissions_number STRING COMMENT '实际录取人数',
                first_choice_number STRING COMMENT '第一志愿报考人数',
                choice_number STRING COMMENT '总报考人数'
      )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

    fn_log "create table ${HIVE_TABLE}"

        load_data    2013zhaosheng.csv
        load_data    2014zhaosheng.csv
        load_data    2015zhaosheng.csv
        load_data    2016zhaosheng.csv
        load_data    2017zhaosheng.csv
}

#职称对应表
function load_zhicheng_info(){

    HIVE_DB=raw
    HIVE_TABLE=load_zhicheng_info
    delete_table

    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
                title_ch STRING COMMENT '中文名称职称职位',
                title_level STRING COMMENT '职称等级',
                title_en STRING COMMENT '英文名称职称职位'
      )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

    fn_log "create table ${HIVE_TABLE}"

        load_data  zhicheng.csv
}

#管理人员类型对应表
function load_guanlirenyuan_info(){

    HIVE_DB=raw
    HIVE_TABLE=load_guanlirenyuan_info
    delete_table

    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
                title_ch STRING COMMENT '中文名称',
                title_en STRING COMMENT '英文名称',
                title_level STRING COMMENT '类型'
      )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

    fn_log "create table ${HIVE_TABLE}"

        load_data  guanlirenyuanleixing.csv
}

#学校负债情况表
function load_school_property(){
    HIVE_DB=raw
    HIVE_TABLE=load_school_property
    delete_table

    #资产,负债,净资产,收入,支出,年末结转,学年

    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            total_assets string comment '资产',
            liabilities string comment '负债',
            true_total_assets string comment '净资产',
            income string comment '收入',
            expenditure string comment '支出',
            end_year_income string comment '年末结转',
            year string comment '年'
      )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    fn_log "create table ${HIVE_TABLE}"

    load_data  school_property.csv
}

#2017年考生信息
function load_exam_student_infomation_2017(){
    HIVE_DB=raw
    HIVE_TABLE=load_exam_student_infomation_2017
    delete_table

    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            id int comment '序号',
            is_register string comment '是否报道',
            province string comment '省份',
            exam_id string comment '考生号',
            pass_exam_id string comment '准考证号',
            name string comment '姓名',
            sex string comment '性别',
            born_date string comment '出生年月',
            political_category string comment '政治面貌',
            nation string comment '民族',
            exam_category string comment '考生类别',
            graduate_type string comment '毕业类别',
            school_name string comment '中学名称',
            foreign_language string comment '外语语种',
            residence_number string comment '考生户口所在地区代码',
            student_local_city string comment '考生户口所在市',
            student_local_place string comment '考生户口所在地区',
            id_card string comment '身份证号',
            address string comment '家庭地址',
            postal_code string comment '邮政编码',
            phone_num string comment '联系电话',
            student_type string comment '考生类型',
            get_person string comment '收件人',
            types string comment '批次',
            family string comment '科类',
            plan_type string comment '计划性质',
            give_scores string comment '投档成绩',
            give_aim string comment '投档志愿',
            department_name string comment '录取系部',
            major_name string comment '录取专业',
            get_method string comment '录取方式',
            chinese string comment '语文',
            math string comment '数学',
            english string comment '外语',
            family_chinese_and_math string comment '文科/理科综合',
            total_score string comment '总分'
      )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    fn_log "create table ${HIVE_TABLE}"

    load_data  Enrolment_information2017.csv
}
#2017年5年制考生信息
function load_exam_student_infomation_201705(){
    HIVE_DB=raw
    HIVE_TABLE=load_exam_student_infomation_201705
    delete_table

    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            id int comment '序号',
            name string comment '姓名',
            id_card string comment '身份证号',
            major_name string comment '专业',
            class_name string comment '班级',
            sex string comment '性别',
            residence_place string comment'考生户口所在地区',
            year string comment '年制',
            book_num string comment '录取通知书编号',
            compare_name string comment '姓名对比',
            result string comment '结果'
      )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    fn_log "create table ${HIVE_TABLE}"

    load_data  Enrolment_information201705.csv
}
#2016年考生信息
function load_exam_student_infomation_2016(){
    HIVE_DB=raw
    HIVE_TABLE=load_exam_student_infomation_2016
    delete_table

    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            id int comment '序号',
            register string comment '学籍注册',
            book_num string comment '录取通知书编号',
            admissions_type string comment '录取性质',
            province string comment '省份',
            family1 string comment '科类1',
            family string comment '科类',
            department_name string comment '录取系部',
            major_name string comment '录取专业',
            exam_id string comment '考生号',
            pass_exam_num string comment '准考证号',
            name string comment '姓名',
            sex string comment '性别',
            political_category string comment '政治面貌',
            nation string comment '民族',
            exam_category string comment '考生类别',
            graduate_type string comment '类别',
            school_name string comment '中学名称',
            foreign_language string comment '外语语种',
            residence_number string comment '考生户口所在地区代码',
            city_name string comment '城市名称',
            county_name string comment '区县名称',
            id_card string comment '身份证号',
            name2 string comment '姓名',
            post_address string comment '邮寄地址',
            postal_code string comment '邮政编码'
      )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    fn_log "create table ${HIVE_TABLE}"

    load_data  Enrolment_information2016.csv
}
#2015年考生信息
function load_exam_student_infomation_2015(){
    HIVE_DB=raw
    HIVE_TABLE=load_exam_student_infomation_2015
    delete_table

    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            id int comment '序号',
            book_num string comment '录取通知书编号',
            admissions_type string comment '录取性质',
            province string comment '省份',
            family string comment '科类',
            department_name string comment '录取系部',
            major_name string comment '录取专业',
            exam_id string comment '考生号',
            name string comment '姓名',
            sex string comment '性别',
            political_category string comment '政治面貌',
            nation string comment '民族',
            exam_category string comment '考生类别',
            school_name string comment '中学名称',
            foreign_language string comment '外语语种',
            residence_number string comment '考生户口所在地区代码',
            city_name string comment '城市名称',
            county_name string comment '区县名称',
            id_card string comment '身份证号',
            is_register string comment '是否报道',
            address string comment '家庭地址',
            postal_code string comment '邮政编码'
      )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    fn_log "create table ${HIVE_TABLE}"

    load_data  Enrolment_information2015.csv
}
#2014年考生信息
function load_exam_student_infomation_2014(){
    HIVE_DB=raw
    HIVE_TABLE=load_exam_student_infomation_2014
    delete_table

    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            id int comment '序号',
            register_num string comment '学籍注册',
            book_num string comment '录取通知书编号',
            admissions_type string comment '录取性质',
            province string comment '省份',
            family string comment '科类',
            department_name string comment '录取系部',
            major_name string comment '录取专业',
            major_num string comment '录取专业代号(陕西专用）',
            exam_id string comment '考生号',
            pass_exam_id string comment '准考证号',
            class_name string comment '专业班级',
            student_no string comment '学号',
            update_class_name string comment '调整后专业班级',
            update_student_no string comment '调整后学号',
            name string comment '姓名',
            sex string comment '性别',
            political_category string comment '政治面貌',
            nation string comment '民族',
            exam_category string comment '考生类别',
            school_name string comment '中学名称',
            foreign_language string comment '外语语种',
            residence_number string comment '考生户口所在地区代码',
            city_name string comment '城市名称',
            county_name string comment '区县名称',
            id_card string comment '身份证号',
            address string comment '邮寄地址',
            postal_code string comment '邮政编码'
      )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    fn_log "create table ${HIVE_TABLE}"

    load_data  Enrolment_information2014.csv
}
#2013年考生信息
function load_exam_student_infomation_2013(){
    HIVE_DB=raw
    HIVE_TABLE=load_exam_student_infomation_2013
    delete_table

    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            register string comment '学籍注册',
            book_num string comment '录取通知书编号',
            admissions_type string comment '录取性质',
            province string comment '省份',
            family string comment '科类',
            department_name string comment '录取系部',
            major_name string comment '录取专业',
            major_no string comment '录取专业代码(陕西专用）',
            exam_id string comment '考生号',
            pass_exam_num string comment '准考证号',
            class_name string comment '专业班级',
            student_no string comment '学号',
            update_class_name string comment '调整后专业班级',
            update_student_no string comment '调整后学号',
            name string comment '姓名',
            sex string comment '性别',
            political_category string comment '政治面貌',
            nation string comment '民族',
            exam_category string comment '考生类别',
            school_name string comment '中学名称',
            foreign_language string comment '外语语种',
            residence_number string comment '考生户口所在地区代码',
            city_name string comment '城市名称',
            county_name string comment '区县名称',
            id_card string comment '身份证号',
            post_address string comment '邮寄地址',
            postal_code string comment '邮政编码'
      )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    fn_log "create table ${HIVE_TABLE}"

    load_data  Enrolment_information2013.csv
}

#学生党费缴纳情况
function student_party_payment(){
    HIVE_DB=raw
    HIVE_TABLE=load_student_party_payment
    delete_table

    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
        id string comment '序号',
        department_name string comment '系名称',
        student_no string comment '学生编号',
        student_name string comment '学生姓名',
        year_2017 string comment '2017年',
        year_2018 string comment '2018年'
      )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    fn_log "create table ${HIVE_TABLE}"

    load_data  student_party_payment.csv
}

#老师党费缴纳情况
function teacher_party_payment(){
    HIVE_DB=raw
    HIVE_TABLE=load_teacher_party_payment
    delete_table

    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
        teacher_no string comment '老师编号',
        teacher_name string comment '老师姓名',
        year_2016 string comment '2016年',
        year_2017 string comment '2017年',
        year_2018 string comment '2018年'
      )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    fn_log "create table ${HIVE_TABLE}"

    load_data  teacher_party_payment.csv
}

#本校主要指标拟合表1（基于2015届、2014届样本）
function department_info_2016(){
    HIVE_DB=raw
    HIVE_TABLE=department_info_2016
    delete_table

    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
        department_name string comment '院系名称',
        employment_rate string comment '就业率',
        mounth_earn string comment '月收入',
        professional_correlation string comment '专业相关度',
        employment_satisfaction string comment '就业满意度',
        separation_rate string comment '离职率',
        alumni_recommendation string comment '校友推荐度',
        alumni_satisfaction string comment '校友满意度'
     )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    fn_log "create table ${HIVE_TABLE}"

    load_data department_info_2016.csv
}

#本校主要指标拟合表2（基于2015届、2014届样本）
function major_info_2016(){
    HIVE_DB=raw
    HIVE_TABLE=major_info_2016
    delete_table

    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
        department_name string comment '院系名称',
        major_name string comment '专业名称',
        employment_rate string comment '就业率',
        mounth_earn string comment '月收入',
        professional_correlation string comment '专业相关度',
        employment_satisfaction string comment '就业满意度',
        separation_rate string comment '离职率',
        alumni_recommendation string comment '校友推荐度',
        alumni_satisfaction string comment '校友满意度'
     )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    fn_log "create table ${HIVE_TABLE}"

    load_data major_info_2016.csv
}

#陕西铁路工程职业技术学院原始数据（2015届短期）
function graduate_student_info_2016(){
    HIVE_DB=raw
    HIVE_TABLE=graduate_student_info_2016
    delete_table

    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
        user_id string comment '用户id',
        student_number string comment '学号',
        student_name string comment '学生姓名',
        department_name string comment '院系名称',
        major_name string comment '专业名称',
        sex string comment '性别',
        go_where string comment '毕业半年后的流向',
        reason string comment '选择专业无关工作的最主要原因',
        satisfaction string comment '对自己现状是否满意',
        earn_money string comment '毕业后半年后的月收入',
        job_name string comment '职业名称',
        job_type string comment '职业类名称',
        industry_type string comment '行业类名称',
        industry_name string comment '行业名称',
        city_name string comment '工作城市名称',
        work_city string comment '工作单位所在地',
        people_number string comment '用人单位规模（即人数）',
        county_type string comment '用人单位类型'
     )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    fn_log "create table ${HIVE_TABLE}"

    load_data graduate_student_info_2016.csv
}

#陕西铁路工程职业技术学院调研原始数据(2015)
function graduate_student_info_2015(){
    HIVE_DB=raw
    HIVE_TABLE=graduate_student_info_2015
    delete_table

    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
        user_id string comment '用户id',
        student_number string comment '学号',
        student_name string comment '学生姓名',
        department_name string comment '院系名称',
        major_name string comment '专业名称',
        sex string comment '性别',
        go_where string comment '毕业半年后的流向',
        reason string comment '选择专业无关工作的最主要原因',
        satisfaction string comment '对自己现状是否满意',
        earn_money string comment '毕业后半年后的月收入',
        job_name string comment '职业名称',
        job_type string comment '职业类名称',
        industry_type string comment '行业类名称',
        industry_name string comment '行业名称',
        city_name string comment '工作城市名称',
        work_city string comment '工作单位所在地',
        people_number string comment '用人单位规模（即人数）',
        county_type string comment '用人单位类型'
     )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    fn_log "create table ${HIVE_TABLE}"

    load_data graduate_student_info_2015.csv
}

#本校主要指标拟合表（基于2016届、2015届样本）
function department_info_2017(){
    HIVE_DB=raw
    HIVE_TABLE=department_info_2017
    delete_table

    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
        department_name string comment '院系名称',
        major_name string comment '专业名称',
        employment_rate string comment '就业率',
        mounth_earn string comment '月收入',
        professional_correlation string comment '专业相关度',
        employment_satisfaction string comment '就业满意度',
        separation_rate string comment '离职率',
        alumni_recommendation string comment '校友推荐度',
        alumni_satisfaction string comment '校友满意度',
        teaching_satisfaction string comment '教学满意度'
     )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    fn_log "create table ${HIVE_TABLE}"

    load_data department_info_2017.csv
}

#陕西铁路工程职业技术学院原始数据(2017)
function graduate_student_info_2017(){
    HIVE_DB=raw
    HIVE_TABLE=graduate_student_info_2017
    delete_table

    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
        user_id string comment '用户id',
        student_number string comment '学号',
        student_name string comment '学生姓名',
        department_name string comment '院系名称',
        major_name string comment '专业名称',
        educational_system string comment '学制',
        sex string comment '性别',
        native_place string comment '籍贯',
        go_where string comment '毕业半年后的流向',
        reason string comment '选择专业无关工作的最主要原因',
        satisfaction string comment '对自己现状是否满意',
        earn_money string comment '毕业后半年后的月收入',
        job_name string comment '职业名称',
        job_type string comment '职业类名称',
        industry_type string comment '行业类名称',
        industry_name string comment '行业名称',
        city_name string comment '工作城市名称',
        work_city string comment '工作单位所在地',
        people_number string comment '用人单位规模（即人数）',
        county_type string comment '用人单位类型'
     )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    fn_log "create table ${HIVE_TABLE}"

    load_data graduate_student_info_2017.csv
}

#党员数据
function department_info(){
    HIVE_DB=raw
    HIVE_TABLE=department_info
    delete_table

    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
        department_name string comment '姓名',
        party_branch string comment '所在党支部',
        id_card string comment '公民身份证号',
        sex string comment '性别',
        nation string comment '民族',
        born_date string comment '出生日期',
        education_history string comment '学历',
        type string comment '人员类别',
        enter_party_date string comment '加入党组织日期',
        change_to_formal_party_member string comment '转为正式党员日期'
     )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    fn_log "create table ${HIVE_TABLE}"

    load_data department_info.csv
}

#党费收入支出信息表
function department_income(){
    HIVE_DB=raw
    HIVE_TABLE=department_income
    delete_table

    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
        year string comment '年度',
        income string comment '收入',
        cost string comment '支出'
     )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    fn_log "create table ${HIVE_TABLE}"

    load_data department_income.csv
}

#党建活动表2016
function department_activity_2016(){
    HIVE_DB=raw
    HIVE_TABLE=department_activity_2016
    delete_table

    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
        no string comment '序号',
        application_unit string comment '申请单位',
        activity_name string comment '特色',
        activity_people string comment '特色党日”活动名称',
        activity_cost string comment '申请经费'
     )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    fn_log "create table ${HIVE_TABLE}"

    load_data department_activity_2016.csv
}

#党建活动表2017
function department_activity_2017(){
    HIVE_DB=raw
    HIVE_TABLE=department_activity_2017
    delete_table

    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
        no string comment '序号',
        application_unit string comment '申请单位',
        activity_name string comment '特色',
        activity_people string comment '特色党日”活动名称',
        activity_cost string comment '申请经费'
     )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    fn_log "create table ${HIVE_TABLE}"

    load_data department_activity_2017.csv
}

#党建活动表2018
function department_activity_2018(){
    HIVE_DB=raw
    HIVE_TABLE=department_activity_2018
    delete_table
    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
        no string comment '序号',
        application_unit string comment '申请单位',
        activity_name string comment '特色党日”活动名称',
        activity_place string comment '活动地点',
        activity_people string comment '负责人',
        people_num string comment '人数',
        activity_cost string comment '经费支持',
        activity_content string comment '活动内容',
        activity_comment string comment '备注'
     )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    fn_log "create table ${HIVE_TABLE}"

    load_data department_activity_2018.csv
}

#帮扶数据(2012-2013学年“一对一”结对帮扶名单)
function help_student_2012_2013(){
    HIVE_DB=raw
    HIVE_TABLE=help_student_2012_2013
    delete_table
    hive -e "
    CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
        id string comment '序号',
        teacher_name string comment '帮扶老师名字',
        department_name string comment '系名称',
        class_name string comment '班级名称',
        student_name string comment '被帮扶学生名字',
        sex string comment '性别',
        phone string comment '电话'

     )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    fn_log "create table ${HIVE_TABLE}"

    load_data help_student_2012_2013.csv
}

#帮扶数据(2013-2014学年“一对一”结对帮扶名单)
function help_student_2013_2014(){
    HIVE_DB=raw
    HIVE_TABLE=help_student_2013_2014
    delete_table
    hive -e "
    CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
        id string comment '序号',
        teacher_name string comment '帮扶老师名字',
        student_no string comment '学号',
        department_name string comment '系名称',
        student_name string comment '被帮扶学生名字',
        class_name string comment '班级名称',
        sex string comment '性别',
        phone string comment '电话'

     )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    fn_log "create table ${HIVE_TABLE}"

    load_data help_student_2013_2014.csv

}
#帮扶数据(2014-2015学年“一对一”结对帮扶名单)
function help_student_2014_2015(){
    HIVE_DB=raw
    HIVE_TABLE=help_student_2014_2015
    delete_table
    hive -e "
    CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
        id string comment '序号',
        teacher_name string comment '帮扶老师名字',
        student_no string comment '学号',
        id_card string comment '身份证号',
        student_name string comment '被帮扶学生名字',
        class_name string comment '班级名称',
        sex string comment '性别',
        phone string comment '电话'
     )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    fn_log "create table ${HIVE_TABLE}"

    load_data help_student_2014_2015.csv

}
#帮扶数据(2015-2016学年“一对一”结对帮扶名单,临渭校区)（load的文件名字写反了，注意下）
function help_student_2015_2016_linwei(){
    HIVE_DB=raw
    HIVE_TABLE=help_student_2015_2016_linwei
    delete_table
    hive -e "
    CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
        id string comment '序号',
        teacher_name string comment '帮扶老师名字',
        party_name string comment '党支',
        teacher_power string comment '帮扶老师的职位',
        department_name string comment '系名称',
        class_name string comment '班级名称',
        student_name string comment '被帮扶学生名字',
        phone string comment '电话'
     )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    fn_log "create table ${HIVE_TABLE}"

    load_data help_student_2015_2016_gaoxin.csv

}
#帮扶数据(2015-2016学年“一对一”结对帮扶名单,高新校区)（load的文件名字写反了，注意下）
function help_student_2015_2016_gaoxin(){
    HIVE_DB=raw
    HIVE_TABLE=help_student_2015_2016_gaoxin
    delete_table
    hive -e "
    CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
        id string comment '序号',
        teacher_name string comment '帮扶老师名字',
        party_name string comment '党支部名称',
        teacher_department_name string comment '帮扶老师所在部门',
        teacher_power string comment '帮扶老师的职位',
        department_name string comment '系名称',
        class_name string comment '班级名称',
        student_name string comment '被帮扶学生名字',
        phone string comment '电话'
     )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    fn_log "create table ${HIVE_TABLE}"

    load_data help_student_2015_2016_linwei.csv

}
#帮扶数据(2016-2017学年“一对一”结对帮扶名单(截止20161212))
function help_student_2016_2017(){
    HIVE_DB=raw
    HIVE_TABLE=help_student_2016_2017
    delete_table
    hive -e "
    CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
        id string comment '序号',
        teacher_name string comment '帮扶老师名字',
        teacher_power string comment '帮扶老师的职位',
        student_name string comment '被帮扶学生名字',
        class_name string comment '班级名称',
        department_name string comment '系名称',
        school_position string comment '校区名称',
        phone string comment '电话'
     )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    fn_log "create table ${HIVE_TABLE}"

    load_data help_student_2016_2017.csv

}
#帮扶数据(2017-2018学年“一对一”结对帮扶名单（截至12月4日）)
function help_student_2017_2018(){
    HIVE_DB=raw
    HIVE_TABLE=help_student_2017_2018
    delete_table
    hive -e "
    CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
        id string comment '序号',
        teacher_name string comment '帮扶老师名字',
        teacher_power string comment '帮扶老师的职位',
        student_name string comment '被帮扶学生名字',
        class_name string comment '班级名称',
        department_name string comment '系名称',
        school_position string comment '校区名称',
        phone string comment '电话',
        address string comment '学生住址'
     )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    fn_log "create table ${HIVE_TABLE}"

    load_data help_student_2017_2018.csv

}
#帮扶数据(陕铁院教师结对帮扶基本情况统计表(截止2018年5月16日))
#function summary_help_teacher(){

#}

#课堂教学分析
    function load_class_teaching_comment(){
        HIVE_DB=raw
        HIVE_TABLE=load_class_teaching_comment
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            id string comment '序号',
            teacher_name string comment '老师名字',
            teacher_no string comment '老师编号',
            faceTeachCount string comment '课堂教学次数',
            oneStar string comment '一星',
            twoStars string comment '二星',
            threeStars string comment '三星',
            fourStars string comment '四星',
            fiveStars string comment '五星',
            signPercent string comment '签到率',
            absencePercent string comment '缺勤率',
            beLatePercent string comment '早退率',
            casualLeavePercent string comment '迟到率',
            sickLeavePercent string comment '病假率',
            earlyLeavePercent string comment '事假率',
            publicAffairLeavePercent string comment '公假率'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

    load_data load_class_teaching_comment.txt
    }
#职教云教师行为（头脑风暴）
    function load_brainstorming(){
        HIVE_DB=raw
        HIVE_TABLE=load_brainstorming
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            name string comment '姓名',
            employeeNum string comment '工号',
            loginTimes string comment '登陆次数',
            docCount string comment '上传资源',
            cellCount string comment '课件',
            questionCount string comment '题目',
            paperCount string comment '试卷',
            homeworkCount string comment '作业',
            examCount string comment '考试',
            unDoHomeworkCount string comment '待批作业',
            unDoOnlineExam string comment '待批试卷',
            groupTaskCount string comment '小组任务',
            signCount string comment '签到',
            brainCount string comment '头脑风暴',
            disscussCount string comment '讨论',
            quizCount string comment '提问',
            classTestCount string comment '测验',
            voteCount string comment '投票',
            groupPkCount string comment '小组pk',
            oneStar string comment '一星',
            twoStar string comment '二星',
            threeStar string comment '三星',
            fourStar string comment '四星',
            fiveStar string comment '五星',
            commentCount string comment '评论',
            askAnswerCount string comment '问答',
            noteCount string comment '笔记',
            errorCount string comment '纠错',
            teacherId string comment '序号'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

    load_data load_brainstorming.txt
    }

#2016-2018所有校区用水电情况
    function load_electricity_water(){
        HIVE_DB=raw
        HIVE_TABLE=load_electricity_water
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            year string comment '年份',
            month string comment '月份',
            campus string comment '校区名称',
            electricity_money string comment '用电金额',
            water_money string comment '用水金额',
            remark string comment '备注'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

    load_data load_electricity_water.csv
    }

#2016-今人员评价情况
    function load_valuation(){
        HIVE_DB=raw
        HIVE_TABLE=load_valuation
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            valuation_name string comment '姓名',
            valuation_num string comment '评价次数',
            valuation_score string comment '评价总分',
            avg_score string comment '平均分',
            time_quantum string comment '能源金额'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

    load_data load_valuation.csv
    }

#专业发展目标
    function load_major_develop_goal(){
        HIVE_DB=raw
        HIVE_TABLE=load_major_develop_goal
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            academe string comment '院系名称',
            major string comment '专业名称',
            develop_goal string comment '专业目标'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

    load_data load_major_develop_goal.csv
    }

#课程体系与教学运行
    function load_courses_education(){
        HIVE_DB=raw
        HIVE_TABLE=load_courses_education
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            major_name string comment '专业名称',
            major_code string comment '专业代码',
			grade_name string comment '年级',
            major_hours string comment '专业总学时',
			major_credit string comment '专业总学分',
            theory_hours string comment '理论学时数',
			practice_hours string comment '实践学时数',
            common_course_hours string comment '公共课程学时数',
			major_course_hours string comment '专业课程学时数',
            course_num string comment '课程门数'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

    load_data load_courses_education.csv
    }

#2014招生计划表
    function load_enrollment_plan_2014(){
        HIVE_DB=raw
        HIVE_TABLE=load_enrollment_plan_2014
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            major_ordinal string comment '专业代号',
            major_name string comment '专业名称',
			subject_type string comment '科类',
            school_system string comment '学制',
			recruit_target string comment '招生对象',
            major_plan string comment '专业计划',
			local_liberty_num string comment '在陕自主招生计划',
            local_accepted_num string comment '在陕高考录取计划',
			outside_num string comment '省外录取人数'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

    load_data load_enrollment_plan_2014.csv
    }

#2015招生计划表
    function load_enrollment_plan_2015(){
        HIVE_DB=raw
        HIVE_TABLE=load_enrollment_plan_2015
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            major_ordinal string comment '专业代号',
            major_name string comment '专业名称',
			major_code string comment '专业代码',
			subject_type string comment '科类',
            school_system string comment '学制',
			recruit_target string comment '招生对象',
            major_plan string comment '专业计划',
			single_recruit string comment '单招',
			local_recruit string comment '本地招生',
            local_sum string comment '本地合计',
			three_school string comment '三校生'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

    load_data load_enrollment_plan_2015.csv
    }

#2016招生计划表
    function load_enrollment_plan_2016(){
        HIVE_DB=raw
        HIVE_TABLE=load_enrollment_plan_2016
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            major_ordinal string comment '专业代号',
            major_name string comment '专业名称',
			academa_name string comment '所属院系',
			subject_type string comment '科类',
            school_system string comment '学制',
			recruit_target string comment '招生对象',
            major_plan string comment '专业计划',
			all_remaining string comment '全国剩余',
            local_num string comment '本地招生人数'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

    load_data load_enrollment_plan_2016.csv
    }

#2017招生计划表
    function load_enrollment_plan_2017(){
        HIVE_DB=raw
        HIVE_TABLE=load_enrollment_plan_2017
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            major_ordinal string comment '专业代号',
            major_name string comment '专业名称',
			major_code string comment '专业代码',
			subject_type string comment '科类',
            school_system string comment '学制',
			recruit_target string comment '招生对象',
            major_plan string comment '专业计划',
			all_remaining string comment '全国剩余',
            local_num string comment '本地招生人数'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

    load_data load_enrollment_plan_2017.csv
    }

#2018招生计划表
    function load_enrollment_plan_2018(){
        HIVE_DB=raw
        HIVE_TABLE=load_enrollment_plan_2018
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            major_ordinal string comment '专业代号',
            major_name string comment '专业名称',
			subject_type string comment '科类',
            school_system string comment '学制',
			recruit_target string comment '招生对象',
            major_plan string comment '专业计划',
			local_liberty_num string comment '在陕自主招生计划'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

    load_data load_enrollment_plan_2018.csv
    }

#资产状况
    function load_asset_status(){
        HIVE_DB=raw
        HIVE_TABLE=load_asset_status
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            card_status string comment '卡片状态',
            asset_num string comment '资产编号',
            asset_name string comment '资产名称',
            education_type string comment '教育大类',
            gb_classify string comment '国标分类',
            asset_classify string comment '资产分类',
            price string comment '单价',
            num string comment '数量',
            measurement string comment '计量单位',
            worth string comment '价值',
            fetch_date string comment '获取日期',
			user string comment '使用人',
            admin_department string comment '管理部门',
            storage_place string comment '存放地点',
            supplier string comment '供货商',
            manufacturers string comment '厂家',
            product_model string comment '规格型号',
            use_direction string comment '使用方向',
            agent string comment '经办人',
            invoice_num string comment '发票号',
            expenditure_subject string comment '经费科目',
            procurement_form string comment '采购形式',
            contract_num string comment '合同号',
            area string comment '面积',
            use_nature string comment '使用性质',
            whether_import string comment '是否进口'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

    load_data load_asset_status.csv
    }

#学院层面资产状况
    function load_academa_asset_status(){
        HIVE_DB=raw
        HIVE_TABLE=load_academa_asset_status
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            year string comment '年度',
            student_sum string comment '学生总数',
			teach_research_val string comment '教学科研仪器设备值',
            teach_research_occ string comment '教学科研及辅助用房',
			office_occ string comment '行政办公用房面积',
			dormitory_area string comment '宿舍面积',
            site_area string comment '实践场所面积',
			teach_calculator_num string comment '教学用计算机台数'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

    load_data load_academa_asset_status.csv
    }

#兼职教师
    function load_pluralistic_teacher(){
        HIVE_DB=raw
        HIVE_TABLE=load_pluralistic_teacher
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            tec_code string comment '教工号',
            tec_name string comment '姓名',
			pluralistic_duty string comment '兼职职务',
            begin_time string comment '开始时间',
			end_time string comment '结束时间'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

    load_data load_pluralistic_teacher.csv
    }

#校内外兼职教师
    function load_all_pluralistic_teacher(){
        HIVE_DB=raw
        HIVE_TABLE=load_all_pluralistic_teacher
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            tec_code string comment '教工号',
            tec_name string comment '姓名',
            begin_time string comment '开始时间',
			end_time string comment '结束时间'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

    load_data load_all_pluralistic_teacher.csv
    }

#老师教学质量工程
    function load_quality_engineering(){
        HIVE_DB=raw
        HIVE_TABLE=load_quality_engineering
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            item_category string comment '项目类别',
            item_name string comment '项目名称',
			content string comment '参赛内容',
			award_rank string comment '获奖等级',
            rewards_bureau string comment '颁奖单位',
			principal string comment '负责人',
			department string comment '部门',
            year string comment '年度',
			bonus string comment '奖金',
            text string comment '备注'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        fn_log "create table ${HIVE_TABLE}"

        load_data load_quality_engineering.csv
    }


#报修信息表（2016年5月～2016年12月）
function load_repair_info_2016_01(){
        HIVE_DB=raw
        HIVE_TABLE=load_repair_info_2016_01
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            repair_no string comment '报修单号',
            status string comment '状态',
            status_time string comment '状态时间',
            repair_time string comment '报修时间',
            project string comment '项目',
            detail string comment '详情',
            area string comment '区域',
            address string comment '详细地址',
            need_repair_person string comment '报修人',
            phone_num string comment '联系方式',
            deal_person string comment '处理人',
            repair_person string comment '维修工',
            request_list_name string comment '报修单名称',
            finished_note string comment '完工备注',
            comment_stars string comment '评价星级',
            comment string comment '评价内容',
            cost_things string comment '耗材'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

    load_data load_repair_info_2016_01.csv
}
#报修信息表（2017年1月～2017年7月）
function load_repair_info_2017_01(){
        HIVE_DB=raw
        HIVE_TABLE=load_repair_info_2017_01
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            repair_no string comment '报修单号',
            status string comment '状态',
            status_time string comment '状态时间',
            repair_time string comment '报修时间',
            project string comment '项目',
            detail string comment '详情',
            area string comment '区域',
            address string comment '详细地址',
            need_repair_person string comment '报修人',
            phone_num string comment '联系方式',
            deal_person string comment '处理人',
            repair_person string comment '维修工',
            request_list_name string comment '报修单名称',
            finished_note string comment '完工备注',
            comment_stars string comment '评价星级',
            comment string comment '评价内容',
            cost_things string comment '耗材'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

    load_data load_repair_info_2017_01.csv

}
#报修信息表（2017年7月～2017年12月）
function load_repair_info_2017_02(){
        HIVE_DB=raw
        HIVE_TABLE=load_repair_info_2017_02
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            repair_no string comment '报修单号',
            status string comment '状态',
            status_time string comment '状态时间',
            repair_time string comment '报修时间',
            project string comment '项目',
            detail string comment '详情',
            area string comment '区域',
            address string comment '详细地址',
            need_repair_person string comment '报修人',
            phone_num string comment '联系方式',
            deal_person string comment '处理人',
            repair_person string comment '维修工',
            request_list_name string comment '报修单名称',
            finished_note string comment '完工备注',
            comment_stars string comment '评价星级',
            comment string comment '评价内容',
            cost_things string comment '耗材'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_repair_info_2017_02.csv

}
#报修信息表（2018年）
function load_repair_info_2018_01(){
        HIVE_DB=raw
        HIVE_TABLE=load_repair_info_2018_01
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            repair_no string comment '报修单号',
            status string comment '状态',
            status_time string comment '状态时间',
            repair_time string comment '报修时间',
            project string comment '项目',
            detail string comment '详情',
            area string comment '区域',
            address string comment '详细地址',
            need_repair_person string comment '报修人',
            phone_num string comment '联系方式',
            deal_person string comment '处理人',
            repair_person string comment '维修工',
            request_list_name string comment '报修单名称',
            finished_note string comment '完工备注',
            comment_stars string comment '评价星级',
            comment string comment '评价内容',
            cost_things string comment '耗材'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

    load_data load_repair_info_2018_01.csv
}

#是否毕业
function load_is_graduate(){
        HIVE_DB=raw
        HIVE_TABLE=load_is_graduate
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            student_no string comment '学号',
            student_name string comment '姓名',
            is_graduate string comment '是否毕业',
            year string comment '年度'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_is_graduate_2016.csv
        load_data load_is_graduate_2017.csv
        load_data load_is_graduate_2018.csv
}

#院办--扶贫情况
function load_help_poor_person_obj(){
        HIVE_DB=raw
        HIVE_TABLE=load_help_poor_person_obj
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            obj_name string comment '项目名称',
            type string comment '类别',
            obj_place string comment '项目实施地点',
            help_obj string comment '扶贫对象',
            help_person_count string comment '扶贫人数',
            money string comment '扶贫金额（元）',
            begin_and_end_time string comment '起止时间',
            join_person string comment '参与人姓名',
            teacher_no string comment '工号',
            is_in_charge string comment '负责人',
            note string comment '备注'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_help_poor_person_obj.csv
}

#媒体报道
function load_media_coverage(){
        HIVE_DB=raw
        HIVE_TABLE=load_media_coverage
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            media_name string comment '媒体名称',
            title string comment '标题',
            report_time string comment '报道时间',
            web_site string comment '网址',
            name string comment '姓名',
            teacher_no string comment '工号',
            author_department string comment '作者所在部门',
            classification string comment '分类',
            level string comment '级别',
            integral string comment '积分',
            note string comment '备注'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_media_coverage.csv
}
#新媒体运营情况
function load_new_media_operation(){
        HIVE_DB=raw
        HIVE_TABLE=load_new_media_operation
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            report_date string comment '日期',
            title string comment '发布文章标题',
            release_platform string comment '发布平台',
            name string comment '姓名',
            teacher_no string comment '工号',
            reading_volume string comment '阅读量',
            integral string comment '积分',
            point_of_praise string comment '点赞量',
            message_volume string comment '留言量',
            note string comment '备注'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_new_media_operation.csv
}
#新媒体排名
function load_new_media_rankings(){
        HIVE_DB=raw
        HIVE_TABLE=load_new_media_rankings
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            date string comment '日期',
            release_platform string comment '发布平台',
            paper_num string comment '文章数',
            reading_num string comment '阅读数',
            avg_reading string comment '平均阅读',
            point_of_praise string comment '点赞数',
            headline string comment '头条',
            WCI string comment 'WCI',
            ranking string comment '排名',
            note string comment '备注'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_new_media_rankings.csv
}
#校园网
function load_web_site(){
        HIVE_DB=raw
        HIVE_TABLE=load_web_site
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            title string comment '标题',
            report_time string comment '报道时间',
            name string comment '姓名',
            teacher_no string comment '工号',
            author_department string comment '作者所在部门',
            integral string comment '积分',
            note string comment '备注'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_web_site.csv
}

#学院层面社会影响
function load_society_influence(){
        HIVE_DB=raw
        HIVE_TABLE=load_society_influence
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            obj_name string comment '项目名称',
            type string comment '类型',
            stu_tec string comment '老师或学生姓名',
            tec_code string comment '工号',
            award_rank string comment '获奖等级',
            level string comment '级别',
            award_time string comment '获奖时间',
            rewards_bureau string comment '颁奖单位',
            academa_award string comment '学院奖励'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"
        fn_log "create table ${HIVE_TABLE}"

        load_data load_society_influence.csv
}

#2017-2018学年社团活动信息表
function load_organization_member_activity(){
        HIVE_DB=raw
        HIVE_TABLE=load_organization_member_activity
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            club_name string comment '社团名称',
            activity_name string comment '活动名称',
            holding_time string comment '举办时间',
            end_time string comment '结束时间',
            join_name string comment '参与人姓名',
            stu_code string comment '学号',
            award_winning string comment '获奖等级',
            other_grades string comment '其他成绩',
            note string comment '备注'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_organization_member_activity.csv
}

#2017-2018学年学生参加社团信息表
function load_student_join_club(){
        HIVE_DB=raw
        HIVE_TABLE=load_student_join_club
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            stu_name string comment '学生姓名',
            stu_code string comment '学号',
            club_name string comment '社团名称',
            join_time string comment '加入时间',
            club_establish_time string comment '社团成立时间',
            adviser string comment '指导老师',
            tec_no string comment '工号',
            note string comment '备注'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_student_join_club.csv
}

#团员团干信息统计
function load_communist_youth_yeague_member(){
        HIVE_DB=raw
        HIVE_TABLE=load_communist_youth_yeague_member
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            id string comment '序号',
            name string comment '团总支名称',
            time string comment '时间',
            develop_person string comment '发展团员人数',
            full_time_person string comment '专职团干部数量',
            part_time_person string comment '兼职团干部数量',
            student_leader_person string comment '学生团干部数量'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data communist_youth_yeague_member.csv
}

#督导听课
function load_supervisor_attend(){
        HIVE_DB=raw
        HIVE_TABLE=load_supervisor_attend
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            teacher_name string comment '授课教师姓名',
            teacher_no string comment '工号',
            department_name string comment '授课教师所在系（部）',
            course_name string comment '课程名称',
            course_code string comment '课程代码',
            class_name string comment '班级名称',
            attend_lecture_date string comment '听课日期',
            which_lecture string comment '听课节次',
            lecture_address string comment '授课地点',
            evaluation_score string comment '督导评分',
            note string comment '备注',
			semester_year string comment '学年',
            semester string comment '学期'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_supervisor_attend.csv
}

#蓝墨云资源库
function load_resource_database(){
        HIVE_DB=raw
        HIVE_TABLE=load_resource_database
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            department_name string comment '院系',
            resource_name string comment '资源名称',
            class_name string comment '班级名称',
            course_name string comment '课程名称',
            course_no string comment '班课号',
            create_person string comment '创建人',
            create_day string comment '创建日期',
            create_time string comment '创建时间',
            visit_times string comment '访问量'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data ziyuanliebiao.txt
}

#企业合作
function load_enterprise_cooperation(){
        HIVE_DB=raw
        HIVE_TABLE=load_enterprise_cooperation
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            enterprise_no string comment '企业编号',
            contract_no string comment '合同编号',
            enterprise_name string comment '企业名称',
            enterprise_type string comment '企业类别',
            cooperation_content string comment '合作内容',
            cooperation_major string comment '合作专业',
            start_time string comment '合作开始时间',
            end_time string comment '合作结束时间'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
		LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

		load_data load_enterprise_cooperation.csv
        }
#教材数量
function load_quantity_teaching_materials(){
        HIVE_DB=raw
        HIVE_TABLE=load_quantity_teaching_materials
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            time string comment '日期',
            name string comment '教材名称',
            ISBN string comment 'ISBN',
            is_plan string comment '是否为规划教材',
            editor string comment '主编',
            press string comment '出版社',
            press_time string comment '出版时间',
            num string comment '数量'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data quantity_teaching_materials.csv
}

#社会培训
function load_society_train(){
        HIVE_DB=raw
        HIVE_TABLE=load_society_train
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            tec_name string comment '姓名',
            tec_code string comment '工号',
			item_code string comment '项目编号',
            item_name string comment '项目名称',
			major_name string comment '所属专业',
            if_principal string comment '是否负责人',
            train_date string comment '培训起止时间',
			semester_year string comment '所属学年',
            duration string comment '时长（天）',
            train_object string comment '培训对象',
            train_num string comment '培训人数',
			contract_time string comment '合同签署时间',
            contract_amount string comment '合同额',
			receive_amount string comment '到款金额',
            informant string comment '填报人',
            auditor string comment '审核人'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
		LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_society_train.csv
}

#校企合作
function load_school_enterprise_cooperation(){
        HIVE_DB=raw
        HIVE_TABLE=load_school_enterprise_cooperation
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            name string comment '教材名称',
            ISBD string comment 'ISBN',
            apply_major string comment '适用专业',
            cooperate_department string comment '合作企业',
            department_name string comment '部门',
            editor string comment '主编',
            press_time string comment '出版日期',
            press_company string comment '出版社'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data school_enterprise_cooperation.csv
}

#函授情况
function load_postal_tuition(){
        HIVE_DB=raw
        HIVE_TABLE=load_postal_tuition
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            annual string comment '年度',
            school_code string comment '学校代码',
            school_name string comment '学校名称',
            pro_course string comment '开设专业',
            major_code string comment '专业代码',
            enrollment string comment '招生人数',
            learning_num string comment '在学人数',
            graduate_num string comment '毕业人数',
            graduation_rate string comment '毕业率',
            informant string comment '填报人',
            auditor string comment '审核人'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

		load_data load_postal_tuition.csv
}

#校企合作文件情况-增加-校企合作处
function load_school_enterprise_cooperation_documents(){
        HIVE_DB=raw
        HIVE_TABLE=load_school_enterprise_cooperation_documents
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            no string comment '编号',
            file_name string comment '文件名称',
            file_type string comment '类别',
            sign_time string comment '签订/发布日期',
            department_name string comment '部门',
            cooperate_company string comment '合作企业名称',
            cooperate_result string comment '主要内容'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data school_enterprise_cooperation_documents.csv
}

#社区服务情况
function load_community_services(){
        HIVE_DB=raw
        HIVE_TABLE=load_community_services
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            tec_name string comment '姓名',
            tec_code string comment '工号',
            item_name string comment '项目名称',
			item_type string comment '项目类别',
            if_principal string comment '是否负责人',
			service_num string comment '服务人数',
            time string comment '起止时间',
            duration string comment '时长（天）',
            service_site string comment '服务地点',
            expenditure string comment '经费',
            informant string comment '填报人',
            auditor string comment '审核人'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_community_services.csv
}

#学院层面—校友工作
    #校友捐赠情况
    function load_alumni_work(){
        HIVE_DB=raw
        HIVE_TABLE=load_alumni_work
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            donation_name string comment '捐赠人',
            donation_using string comment '用途（对象）',
            donation_way string comment '捐赠方式',
            donation_money string comment '金额（折算金额）',
            department_name string comment '管理部门',
            donation_time string comment '捐赠时间',
            note string comment '备注'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data alumni_work.csv
    }
    #校友情况
    function load_alumni_situation(){
        HIVE_DB=raw
        HIVE_TABLE=load_alumni_situation
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            graduate_time string comment '毕业时间',
            name string comment '毕业学生姓名',
            major string comment '专业',
            sex string comment '性别',
            political_outlook string comment '政治面貌',
            work_department string comment '工作单位',
            duty string comment '职务',
            phone string comment '联系方式',
            qq string comment 'QQ',
            wechat string comment '微信号',
            note string comment '备注'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_alumni_situation.csv
    }
    #校友会情况
    function load_alumni_association(){
        HIVE_DB=raw
        HIVE_TABLE=load_alumni_association
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            name string comment '校友会名称',
            build_time string comment '成立时间',
            num string comment '校友会人数',
            note string comment '备注'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_alumni_association.csv
    }
    #校友活动情况
    function load_alumni_activities(){
        HIVE_DB=raw
        HIVE_TABLE=load_alumni_activities
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            activity_name string comment '活动名称',
            activity_comment string comment '活动内容',
            num string comment '参与人数',
            activity_time string comment '活动时间',
            note string comment '备注'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_alumni_activities.csv
    }

#教师层面数据汇总（2018.8.1)
    #3.1.13教学事故
    function load_teaching_accident(){
        HIVE_DB=raw
        HIVE_TABLE=load_teaching_accident
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            name string comment '姓名',
            teacher_no string comment '工号',
            level string comment '级别',
            accident_type string comment '类型',
            accident_comment string comment '事故内容',
            accident_date string comment '日期',
            deal_suggests string comment '处理意见'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data teaching_accident.csv
    }
    #3.2.1参与专业建设情况（汇总）
    function load_participation_in_professional_construction(){
        HIVE_DB=raw
        HIVE_TABLE=load_participation_in_professional_construction
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            name string comment '姓名',
            teacher_no string comment '工号',
            join_build_major_name string comment '参与建设专业名称',
            join_comment string comment '参与建设内容',
            build_begin_date string comment '建设开始日期',
            build_end_date string comment '建设结束日期',
            charge_person_name string comment '负责人/参与人'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data participation_in_professional_construction.csv
    }
    #3.2.2参与建设课程（汇总）
    function load_participate_in_the_construction_course(){
        HIVE_DB=raw
        HIVE_TABLE=load_participate_in_the_construction_course
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            name string comment '姓名',
            teacher_no string comment '工号',
            join_build_major_name string comment '参与建设课程名称',
            join_comment string comment '参与建设内容',
            build_begin_date string comment '建设开始日期',
            build_end_date string comment '建设结束日期',
            charge_person_name string comment '负责人/参与人'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data participate_in_the_construction_course.csv
    }
    #3.2.3参与实训基地建设情况（汇总）
    function load_participate_in_the_construction_of_training_base(){
        HIVE_DB=raw
        HIVE_TABLE=load_participate_in_the_construction_of_training_base
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            name string comment '姓名',
            teacher_no string comment '工号',
            join_build_major_name string comment '参与建设专业名称',
            join_comment string comment '参与建设内容',
            build_begin_date string comment '建设开始日期',
            build_end_date string comment '建设结束日期',
            charge_person_name string comment '负责人/参与人'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data participate_in_the_construction_of_training_base.csv
    }
    #3.4.5教学质量工程积分（教学科）
    function load_teaching_quality_engineering_integral(){
        HIVE_DB=raw
        HIVE_TABLE=load_teaching_quality_engineering_integral
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            name string comment '姓名',
            teacher_no string comment '工号',
            department_name string comment '部门',
            teaching_quality_name string comment '教学质量工程获奖名称',
            level string comment '获奖等级',
            earn_date string comment '获奖时间',
            give_department string comment '颁奖单位',
            score string comment '计分（新增）',
            load_person string comment '填报人',
            look_person string comment '审批人',
            comment_person string comment '汇总人'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data teaching_quality_engineering_integral.csv
    }

#1学院层面（开发课程与教材）
    #校企合作共同开发教材
    function load_college_teaching_material(){
        HIVE_DB=raw
        HIVE_TABLE=load_college_teaching_material
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            name string comment '教材名称',
            ISBN string comment 'ISBN',
            apply_major string comment '适用专业',
            cooperate_company string comment '合作企业',
            section_name string comment '部门',
            post_date string comment '出版日期',
			department_name string comment '院系名称',
            department_no string comment '院系代码'		
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_college_teaching_material.csv
    }
    #课程 需要未抽取
    function load_college_course(){
        HIVE_DB=raw
        HIVE_TABLE=load_college_course
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            course_name string comment '课程名称',
            course_code string comment '课程代码',
            apply_major string comment '适用专业',
            cooperate_company string comment '合作企业',
            section_name string comment '部门',
            develop_date string comment '开发日期',
			department_name string comment '院系名称',
            department_no string comment '院系代码'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_college_course.csv
    }

#近三年教学任务
    #2015-2016-1
    function load_teaching_task_2015_2016_1(){
        HIVE_DB=raw
        HIVE_TABLE=load_teaching_task_2015_2016_1
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            school_area_name string comment '校区',
            class_name string comment '班级名称',
            school_type string comment '办学形式',
            class_num string comment '班级人数',
            follow_class_num string comment '跟班人数',
            old_course_code string comment '原课程代码',
            new_course_code string comment '新课程代码',
            course_name string comment '课程名称',
            course_teacher string comment '任课教师',
            teacher_no string comment '教师编号',
            help_teacher_no string comment '辅导教师编号',
            help_teacher_name string comment '辅导教师',
            experiment_teacher_no string comment '实验教师编号',
            experiment_teacher_name string comment '实验教师',
            place_require string comment '场地要求',
            sex string comment '性别',
            week_time string comment '周课时',
            begin_week_and_end_week string comment '起止周',
            experiment_begin_week_and_end_week string comment '实验起止周',
            level string comment '等级',
            course_type string comment '课程性质',
            using_department string comment '开课部门',
            exam_method string comment '考核方式',
            mix_class_name string comment '合班名称',
            experiment_mix_class_name string comment '实验合班名称',
            study_score string comment '学分',
            experiment_course_week_time string comment '实践课周数',
            sum_course_time string comment '总课时',
            semester_year string comment '学年',
            semester string comment '学期',
            major_code string comment '专业代码',
            major_name string comment '专业名称',
            grade_name string comment '年级',
            major_direction string comment '专业方向',
            belong_part string comment '所属模块',
            ISBN string comment '教材ISBN',
            teaching_material_name string comment '教材名称',
            press_name string comment '出版社',
            author_name string comment '教材著者',
            price string comment '单价',
            teaching_material_edition string comment '教材版别',
            teaching_material_type string comment '教材类型',
            experiment_large string comment '实验容量',
            experiment_place_require string comment '实验场地要求',
            mark_bit string comment '标示位',
            no string comment '序号',
            theoretical_hours string comment '理论课时',
            experimental_class string comment '实验课时',
            class_time string comment '上机课时',
            curriculum_category string comment '课程类别',
            curriculum_type string comment '课程类型',
            lecture_section string comment '授课章节',
            note string comment '备注',
            teacher_using_book string comment '教师用书',
            choose_course_status string comment '选课状态',
            sum_week_time string comment '总周数',
            teaching_material_note string comment '教材备注',
            excellent_teaching_materials string comment '优秀教材',
            publish_date string comment '出版日期',
            note_and_instruction string comment '备注与说明',
            teacher_belong_department string comment '教师所属部门',
            plan_start_course_semester string comment '计划开课学期',
            begin_and_end_week_first_num string comment '起始结束周原始值',
            exam_time_date string comment '考试时间段',
            plan_sum_course_time string comment '计划总课时',
            exam_method_name string comment '考试方式',
            class_code string comment '班级代码',
            using_study_room string comment '开课教研室'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_teaching_task_2015-2016-1.csv
    }
    #2015-2016-2
    function load_teaching_task_2015_2016_2(){
        HIVE_DB=raw
        HIVE_TABLE=load_teaching_task_2015_2016_2
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            school_area_name string comment '校区',
            class_name string comment '班级名称',
            school_type string comment '办学形式',
            class_num string comment '班级人数',
            follow_class_num string comment '跟班人数',
            old_course_code string comment '原课程代码',
            new_course_code string comment '新课程代码',
            course_name string comment '课程名称',
            course_teacher string comment '任课教师',
            teacher_no string comment '教师编号',
            help_teacher_no string comment '辅导教师编号',
            help_teacher_name string comment '辅导教师',
            experiment_teacher_no string comment '实验教师编号',
            experiment_teacher_name string comment '实验教师',
            place_require string comment '场地要求',
            sex string comment '性别',
            week_time string comment '周课时',
            begin_week_and_end_week string comment '起止周',
            experiment_begin_week_and_end_week string comment '实验起止周',
            level string comment '等级',
            course_type string comment '课程性质',
            using_department string comment '开课部门',
            exam_method string comment '考核方式',
            mix_class_name string comment '合班名称',
            experiment_mix_class_name string comment '实验合班名称',
            study_score string comment '学分',
            experiment_course_week_time string comment '实践课周数',
            sum_course_time string comment '总课时',
            semester_year string comment '学年',
            semester string comment '学期',
            major_code string comment '专业代码',
            major_name string comment '专业名称',
            grade_name string comment '年级',
            major_direction string comment '专业方向',
            belong_part string comment '所属模块',
            ISBN string comment '教材ISBN',
            teaching_material_name string comment '教材名称',
            press_name string comment '出版社',
            author_name string comment '教材著者',
            price string comment '单价',
            teaching_material_edition string comment '教材版别',
            teaching_material_type string comment '教材类型',
            experiment_large string comment '实验容量',
            experiment_place_require string comment '实验场地要求',
            mark_bit string comment '标示位',
            no string comment '序号',
            theoretical_hours string comment '理论课时',
            experimental_class string comment '实验课时',
            class_time string comment '上机课时',
            curriculum_category string comment '课程类别',
            curriculum_type string comment '课程类型',
            lecture_section string comment '授课章节',
            note string comment '备注',
            teacher_using_book string comment '教师用书',
            choose_course_status string comment '选课状态',
            sum_week_time string comment '总周数',
            teaching_material_note string comment '教材备注',
            excellent_teaching_materials string comment '优秀教材',
            publish_date string comment '出版日期',
            note_and_instruction string comment '备注与说明',
            teacher_belong_department string comment '教师所属部门',
            plan_start_course_semester string comment '计划开课学期',
            begin_and_end_week_first_num string comment '起始结束周原始值',
            exam_time_date string comment '考试时间段',
            plan_sum_course_time string comment '计划总课时',
            exam_method_name string comment '考试方式',
            class_code string comment '班级代码',
            using_study_room string comment '开课教研室'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_teaching_task_2015-2016-2.csv
    }
    #2016-2017-1
    function load_teaching_task_2016_2017_1(){
        HIVE_DB=raw
        HIVE_TABLE=load_teaching_task_2016_2017_1
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            school_area_name string comment '校区',
            class_name string comment '班级名称',
            school_type string comment '办学形式',
            class_num string comment '班级人数',
            follow_class_num string comment '跟班人数',
            old_course_code string comment '原课程代码',
            new_course_code string comment '新课程代码',
            course_name string comment '课程名称',
            course_teacher string comment '任课教师',
            teacher_no string comment '教师编号',
            help_teacher_no string comment '辅导教师编号',
            help_teacher_name string comment '辅导教师',
            experiment_teacher_no string comment '实验教师编号',
            experiment_teacher_name string comment '实验教师',
            place_require string comment '场地要求',
            sex string comment '性别',
            week_time string comment '周课时',
            begin_week_and_end_week string comment '起止周',
            experiment_begin_week_and_end_week string comment '实验起止周',
            level string comment '等级',
            course_type string comment '课程性质',
            using_department string comment '开课部门',
            exam_method string comment '考核方式',
            mix_class_name string comment '合班名称',
            experiment_mix_class_name string comment '实验合班名称',
            study_score string comment '学分',
            experiment_course_week_time string comment '实践课周数',
            sum_course_time string comment '总课时',
            semester_year string comment '学年',
            semester string comment '学期',
            major_code string comment '专业代码',
            major_name string comment '专业名称',
            grade_name string comment '年级',
            major_direction string comment '专业方向',
            belong_part string comment '所属模块',
            ISBN string comment '教材ISBN',
            teaching_material_name string comment '教材名称',
            press_name string comment '出版社',
            author_name string comment '教材著者',
            price string comment '单价',
            teaching_material_edition string comment '教材版别',
            teaching_material_type string comment '教材类型',
            experiment_large string comment '实验容量',
            experiment_place_require string comment '实验场地要求',
            mark_bit string comment '标示位',
            no string comment '序号',
            theoretical_hours string comment '理论课时',
            experimental_class string comment '实验课时',
            class_time string comment '上机课时',
            curriculum_category string comment '课程类别',
            curriculum_type string comment '课程类型',
            lecture_section string comment '授课章节',
            note string comment '备注',
            teacher_using_book string comment '教师用书',
            choose_course_status string comment '选课状态',
            sum_week_time string comment '总周数',
            teaching_material_note string comment '教材备注',
            excellent_teaching_materials string comment '优秀教材',
            publish_date string comment '出版日期',
            note_and_instruction string comment '备注与说明',
            teacher_belong_department string comment '教师所属部门',
            plan_start_course_semester string comment '计划开课学期',
            begin_and_end_week_first_num string comment '起始结束周原始值',
            exam_time_date string comment '考试时间段',
            plan_sum_course_time string comment '计划总课时',
            exam_method_name string comment '考试方式',
            class_code string comment '班级代码',
            using_study_room string comment '开课教研室'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_teaching_task_2016-2017-1.csv
    }
    #2016-2017-2
    function load_teaching_task_2016_2017_2(){
        HIVE_DB=raw
        HIVE_TABLE=load_teaching_task_2016_2017_2
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            school_area_name string comment '校区',
            class_name string comment '班级名称',
            school_type string comment '办学形式',
            class_num string comment '班级人数',
            follow_class_num string comment '跟班人数',
            old_course_code string comment '原课程代码',
            new_course_code string comment '新课程代码',
            course_name string comment '课程名称',
            course_teacher string comment '任课教师',
            teacher_no string comment '教师编号',
            help_teacher_no string comment '辅导教师编号',
            help_teacher_name string comment '辅导教师',
            experiment_teacher_no string comment '实验教师编号',
            experiment_teacher_name string comment '实验教师',
            place_require string comment '场地要求',
            sex string comment '性别',
            week_time string comment '周课时',
            begin_week_and_end_week string comment '起止周',
            experiment_begin_week_and_end_week string comment '实验起止周',
            level string comment '等级',
            course_type string comment '课程性质',
            using_department string comment '开课部门',
            exam_method string comment '考核方式',
            mix_class_name string comment '合班名称',
            experiment_mix_class_name string comment '实验合班名称',
            study_score string comment '学分',
            experiment_course_week_time string comment '实践课周数',
            sum_course_time string comment '总课时',
            semester_year string comment '学年',
            semester string comment '学期',
            major_code string comment '专业代码',
            major_name string comment '专业名称',
            grade_name string comment '年级',
            major_direction string comment '专业方向',
            belong_part string comment '所属模块',
            ISBN string comment '教材ISBN',
            teaching_material_name string comment '教材名称',
            press_name string comment '出版社',
            author_name string comment '教材著者',
            price string comment '单价',
            teaching_material_edition string comment '教材版别',
            teaching_material_type string comment '教材类型',
            experiment_large string comment '实验容量',
            experiment_place_require string comment '实验场地要求',
            mark_bit string comment '标示位',
            no string comment '序号',
            theoretical_hours string comment '理论课时',
            experimental_class string comment '实验课时',
            class_time string comment '上机课时',
            curriculum_category string comment '课程类别',
            curriculum_type string comment '课程类型',
            lecture_section string comment '授课章节',
            note string comment '备注',
            teacher_using_book string comment '教师用书',
            choose_course_status string comment '选课状态',
            sum_week_time string comment '总周数',
            teaching_material_note string comment '教材备注',
            excellent_teaching_materials string comment '优秀教材',
            publish_date string comment '出版日期',
            note_and_instruction string comment '备注与说明',
            teacher_belong_department string comment '教师所属部门',
            plan_start_course_semester string comment '计划开课学期',
            begin_and_end_week_first_num string comment '起始结束周原始值',
            exam_time_date string comment '考试时间段',
            plan_sum_course_time string comment '计划总课时',
            exam_method_name string comment '考试方式',
            class_code string comment '班级代码',
            using_study_room string comment '开课教研室'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_teaching_task_2016-2017-2.csv
    }
    #2017-2018-1
    function load_teaching_task_2017_2018_1(){
        HIVE_DB=raw
        HIVE_TABLE=load_teaching_task_2017_2018_1
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
school_area_name string comment '校区',
student_num string comment '人数',
selected_student_num string comment '已选人数',
teaching_class string comment '教学班组成',
course_code string comment '课程代码',
new_course_code string comment '新课程代码',
course_name string comment '课程名称',
teacher_code string comment '教职工号',
teacher_name string comment '教师姓名',
professional_title string comment '职称',
selected_course_code string comment '选课课号',
week_course_time string comment '周学时',
using_department string comment '开课学院',
start_end_week string comment '起止周',
study_score string comment '学分',
total_course_time string comment '总学时',
teaching_course_time string comment '讲课学时',
experiment_course_time string comment '实验学时',
machine_course_time string comment '上机学时',
out_class_course_time string comment '课外学时',
class_experiment_course_time string comment '课程实践学时',
exercise_course_time string comment '习题课学时',
onclass_machine_course_time string comment '课内上机学时',
outclass_experiment_course_time string comment '课外实践学时',
exam_type string comment '考核方式',
course_nature string comment '课程性质',
course_type string comment '课程类别',
area_require string comment '场地要求',
textbook_name string comment '教材名称',
textbook_author string comment '作者',
textbook_publisher string comment '出版社',
textbook_version string comment '版别',
reward string comment '获奖情况',
experiment_area string comment '试验场地',
course_time string comment '上课时间',
teaching_class1 string comment '教学班组成1',
experiment_class_num string comment '实验班级数',
note string comment '备注',
department_name string comment '学生学院'


         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_teaching_task_2017-2018-1.csv
    }
    #2017-2018-2
    function load_teaching_task_2017_2018_2(){
        HIVE_DB=raw
        HIVE_TABLE=load_teaching_task_2017_2018_2
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            school_area_name string comment '校区',
student_num string comment '人数',
selected_student_num string comment '已选人数',
teaching_class string comment '教学班组成',
course_code string comment '课程代码',
new_course_code string comment '新课程代码',
course_name string comment '课程名称',
teacher_code string comment '教职工号',
teacher_name string comment '教师姓名',
professional_title string comment '职称',
selected_course_code string comment '选课课号',
week_course_time string comment '周学时',
using_department string comment '开课学院',
start_end_week string comment '起止周',
study_score string comment '学分',
total_course_time string comment '总学时',
teaching_course_time string comment '讲课学时',
experiment_course_time string comment '实验学时',
machine_course_time string comment '上机学时',
out_class_course_time string comment '课外学时',
class_experiment_course_time string comment '课程实践学时',
exercise_course_time string comment '习题课学时',
onclass_machine_course_time string comment '课内上机学时',
outclass_experiment_course_time string comment '课外实践学时',
exam_type string comment '考核方式',
course_nature string comment '课程性质',
course_type string comment '课程类别',
area_require string comment '场地要求',
textbook_name string comment '教材名称',
textbook_author string comment '作者',
textbook_publisher string comment '出版社',
textbook_version string comment '版别',
reward string comment '获奖情况',
experiment_area string comment '试验场地',
course_time string comment '上课时间',
teaching_class1 string comment '教学班组成1',
experiment_class_num string comment '实验班级数',
note string comment '备注',
department_name string comment '学生学院'


         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_teaching_task_2017-2018-2.csv
    }

#合作企业订单培养人数（黄老师又重新提供了一份）
function load_enterprise_cultivate(){
        HIVE_DB=raw
        HIVE_TABLE=load_enterprise_cultivate
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            stu_name string comment '姓名',
            stu_code string comment '学号',
            cultivate_type string comment '培养类别',
			major_name string comment '专业名称',
            class_name string comment '班级名称',
			enterprise_no string comment '企业编号',
            enterprise_name string comment '企业名称',
            naming string comment '冠名名称',
            cultivate_start_date string comment '培养开始日期',			
            cultivate_end_date string comment '培养结束日期',
			if_hire string comment '是否被订单企业录用',
            informant string comment '填报人',
            auditor string comment '审核人'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"
        fn_log "create table ${HIVE_TABLE}"
		
        load_data load_enterprise_cultivate.csv
}

#校内取证统计表
function load_credential_statistics(){
        HIVE_DB=raw
        HIVE_TABLE=load_credential_statistics
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            stu_name string comment '姓名',
            id_card string comment '身份证号',
			stu_code string comment '学号',
            apply_date string comment '报名时间',
			credential_code string comment '证书编号',
            exam_date string comment '考试时间',
			credential_name string comment '证书名称',
            type_work string comment '工种名称',
            examinee_type string comment '考生类型',
            tests_grade string comment '理论成绩',			
            actual_grade string comment '实操成绩',
            comment string comment '备注'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"
		
        load_data load_credential_statistics.csv
}

#2015-2016奖学金获奖情况
function load_scholarship_condition_2015_2016(){
        HIVE_DB=raw
        HIVE_TABLE=load_scholarship_condition_2015_2016
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            class_grade string comment '班级',
			stu_name string comment '姓名',            
			sex string comment '性别',
            scholarship_amount string comment '奖学金金额',
			id_card string comment '身份证号'			
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"
		
        load_data load_scholarship_condition_2015_2016.csv
}

#2016-2017奖学金获奖情况
function load_scholarship_condition_2016_2017(){
        HIVE_DB=raw
        HIVE_TABLE=load_scholarship_condition_2016_2017
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            class_grade string comment '班级',
			stu_name string comment '姓名',            
			sex string comment '性别',
            scholarship_amount string comment '奖学金金额',
			id_card string comment '身份证号'			
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"
		
        load_data load_scholarship_condition_2016_2017.csv
}


#2016-2017，2017-2018国家奖学金情况
function load_national_scholarship(){
        HIVE_DB=raw
        HIVE_TABLE=load_national_scholarship
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            student_name string comment '姓名',
            student_no string comment '学号',
            degree string comment '学历',
            department_name string comment '院系',
            grade string comment '年级'
            major_name string comment '专业名称',
            class_name string comment '班级名称',
            id_card string comment '身份证号',
            native_place string comment '生源省份',
            award_level string comment '奖励等级'
            amount string comment '奖励金额',
            card_number string comment '卡号',
            annual string comment '年度',
            contract_number string comment '联系电话'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_national_scholarship.csv
}

#专业基本情况
function load_professional_basic_situation(){
        HIVE_DB=raw
        HIVE_TABLE=load_professional_basic_situation
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            id String comment '序号',
            semester_year String comment '学年',
            major_code String comment '专业代码',
            major_name String comment '专业名称',
            major_set_time String comment '专业设置时间',
            major_set_basic_info String comment '专业建设基础',
            major_set_aim String comment '专业建设目标',
            input_person String comment '填报人',
            examine_person String comment '审核人',
            summary_person String comment '汇总人'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_professional_basic_situation.csv
}

#专业目录情况
function load_professional_catalogues(){
        HIVE_DB=raw
        HIVE_TABLE=load_professional_catalogues
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            department_name String comment '所属系部',
            major_big_type String comment '专业大类',
            major_type String comment '专业类',
            major_name String comment '专业名称',
            major_code String comment '专业代码',
            is_plan_find_student_in_2017 String comment '17年是否招生',
            is_5_year String comment '是否有5年制',
            instruction String comment '说明'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_professional_catalogues.csv
}
#捐赠设备情况
    function load_situation_of_donation_equipment(){
        HIVE_DB=raw
        HIVE_TABLE=load_situation_of_donation_equipment
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            id String comment '序号',
            semester_year String comment '学年',
            major_code String comment '专业代码',
            major_name String comment '专业名称',
            cooperation_company String comment '合作企业名称',
            donation_time String comment '捐赠时间',
            donation_equipment_name String comment '捐赠设备名称',
            donation_equipment_num String comment '捐赠设备数量',
            donation_equipment_pay String comment '捐赠设备价值',
            input_person String comment '填报人',
            look_person String comment '审核人',
            summary_person String comment '汇总人'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_situation_of_donation_equipment.csv
    }
	
#资源库信息表
    function load_major_resource_pool_info(){
        HIVE_DB=raw
        HIVE_TABLE=load_major_resource_pool_info
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            major_name String comment '专业名称',
            major_no String comment '专业编号',
            pool_name String comment '资源库名称',
            project_approval_time String comment '立项时间',
            pool_level String comment '资源库等级',
            participation String comment '主持/参与',           
            input_person String comment '填报人',
            look_person String comment '审核人',
            summary_person String comment '汇总人'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_major_resource_pool_info.csv
    }
	
#课程改革信息
    function load_reform_course_info(){
        HIVE_DB=raw
        HIVE_TABLE=load_reform_course_info
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            semester_year String comment '学年',
            semester String comment '学期',
            year String comment '年',
            course_name String comment '课程名称',
            course_code String comment '课程编号',
            construction_goals String comment '建设目标',
            accomplish_time String comment '目标完成时间',			
            input_person String comment '填报人',
            look_person String comment '审核人',
            summary_person String comment '汇总人'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_reform_course_info.csv
    }
	
#教学改革项目信息
    function load_reform_project_info(){
        HIVE_DB=raw
        HIVE_TABLE=load_reform_project_info
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
		    id String comment '序号',
			semester_year String comment '学年',
			major_name String comment '专业名称',
			major_no String comment '专业编号',
			activity_people string comment '负责人',
			project_name string comment '项目名称',
			begin_time string comment '项目开始时间',
			if_award string comment '是否获奖',
            project_approval_level String comment '立项等级',
            project_approval_unit String comment '立项单位'           
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_reform_project_info.csv
    }
#科研成果获奖
    function load_award_winning_scientific_research_achievements(){
        HIVE_DB=raw
        HIVE_TABLE=load_award_winning_scientific_research_achievements
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            name string comment '姓名',
            teacher_no string comment '工号',
            department_name string comment '所属部门',
            award_type string comment '获奖类型',
            award_name string comment '获奖名称',
            award_level string comment '获奖级别',
            award_time string comment '获奖时间',
            give_award_department string comment '颁奖单位',
            input_person string comment '填报人',
            look_person string comment '审核人',
            comment_person string comment '汇总人'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_award_winning_scientific_research_achievements.csv
    }
#精品在线开放课程
    function load_boutique_online_open_course(){
        HIVE_DB=raw
        HIVE_TABLE=load_boutique_online_open_course
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            id string comment '序号',
            semester_year string comment '学年',
            course_name string comment '课程名称',
            course_code string comment '课程代码',
            course_degree string comment '课程等级（国家级/省级/院级）',
            input_person string comment '填报人',
            look_person string comment '审核人',
            comment_person string comment '汇总人'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_boutique_online_open_course.csv
    }
#教师归属
    function load_teacher_ownership(){
        HIVE_DB=raw
        HIVE_TABLE=load_teacher_ownership
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            id string comment '序号',
            teacher_no string comment '工号',
            teacher_name string comment '姓名',
            department_name string comment '所属系部',
            belong_room string comment '所属教研室',
            belong_major string comment '归属专业',
            full_time_teacher string comment '专任教师'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_teacher_ownership2.csv
    }
	
#系统库匹配国标专业代码
    function load_matching_major_code(){
        HIVE_DB=raw
        HIVE_TABLE=load_matching_major_code
        delete_table
        hive -e "
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            major_name string comment '专业名称',
            major_gb_code string comment '国标专业代码',
            major_xt_code string comment '系统库专业代码'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "
        fn_log "create table ${HIVE_TABLE}"

        load_data load_matching_major_code.csv
    }

#2015-2016(2)征订汇总表
    function load_subscription_summary_sheet_2015_2016_02(){
        HIVE_DB=raw
        HIVE_TABLE=load_subscription_summary_sheet_2015_2016_02
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
           id string comment '序号',
           course_name string comment '课程名称',
           material_name string comment '教材名称',
           material_degree string comment '教材等级',
           author string comment '作者',
           publish_name string comment '出版社',
           publish_date string comment '版本及出版日期',
           apply_class string comment '适用班级',
           num string comment '数量'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_subscription_summary_sheet_2015_2016_02.csv
    }

#2015-2016学年第一学期征订汇总表（老生）
    function load_subscription_summary_sheet_2015_2016_01()
    {
        HIVE_DB=raw
        HIVE_TABLE=load_subscription_summary_sheet_2015_2016_01
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
           id string comment '序号',
           course_name string comment '课程名称',
           material_name string comment '教材名称',
           material_degree string comment '教材等级',
           author string comment '作者',
           publish_name string comment '出版社',
           publish_date string comment '版本及出版日期',
           apply_class string comment '适用班级',
           num string comment '数量'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_subscription_summary_sheet_2015_2016_01.csv
    }
#2015-2016征订汇总表（新生）
    function load_subscription_summary_sheet_2015_2016_01_new()
    {
        HIVE_DB=raw
        HIVE_TABLE=load_subscription_summary_sheet_2015_2016_01_new
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
           id string comment '序号',
           course_name string comment '课程名称',
           material_name string comment '教材名称',
           material_degree string comment '教材等级',
           author string comment '作者',
           publish_name string comment '出版社',
           publish_date string comment '版本及出版日期',
           apply_class string comment '适用班级',
           num string comment '数量'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_subscription_summary_sheet_2015_2016_01_new.csv
    }
#2016-2017(2)征订汇总表
    function load_subscription_summary_sheet_2016_2017_02()
    {
        HIVE_DB=raw
        HIVE_TABLE=load_subscription_summary_sheet_2016_2017_02
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
           id string comment '序号',
           course_name string comment '课程名称',
           material_name string comment '教材名称',
           material_degree string comment '教材等级',
           author string comment '作者',
           publish_name string comment '出版社',
           publish_date string comment '版本及出版日期',
           apply_class string comment '适用班级',
           num string comment '数量'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_subscription_summary_sheet_2016_2017_02.csv
    }
#2016-2017学年第一学期征订汇总表（老生）
    function load_subscription_summary_sheet_2016_2017_01()
    {
        HIVE_DB=raw
        HIVE_TABLE=load_subscription_summary_sheet_2016_2017_01
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
           id string comment '序号',
           course_name string comment '课程名称',
           material_name string comment '教材名称',
           material_degree string comment '教材等级',
           author string comment '作者',
           publish_name string comment '出版社',
           publish_date string comment '版本及出版日期',
           apply_class string comment '适用班级',
           num string comment '数量'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_subscription_summary_sheet_2016_2017_01.csv
    }
#2016-2017学年第一学期征订汇总表（新生）
    function load_subscription_summary_sheet_2016_2017_01_new()
    {
        HIVE_DB=raw
        HIVE_TABLE=load_subscription_summary_sheet_2016_2017_01_new
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
           id string comment '序号',
           course_name string comment '课程名称',
           material_name string comment '教材名称',
           material_degree string comment '教材等级',
           author string comment '作者',
           publish_name string comment '出版社',
           publish_date string comment '版本及出版日期',
           apply_class string comment '适用班级',
           num string comment '数量'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_subscription_summary_sheet_2016_2017_01_new.csv
    }

#2017-2018(1)征订汇总表（老生）
    function load_subscription_summary_sheet_2017_2018_01()
    {
        HIVE_DB=raw
        HIVE_TABLE=load_subscription_summary_sheet_2017_2018_01
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
           id string comment '序号',
           course_name string comment '课程名称',
           material_name string comment '教材名称',
           material_degree string comment '教材等级',
           author string comment '作者',
           publish_name string comment '出版社',
           publish_date string comment '版本及出版日期',
           apply_class string comment '适用班级',
           num string comment '数量'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_subscription_summary_sheet_2017_2018_01.csv
    }

#2017-2018第二学期征订汇总表
    function load_subscription_summary_sheet_2017_2018_02()
    {
        HIVE_DB=raw
        HIVE_TABLE=load_subscription_summary_sheet_2017_2018_02
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
           id string comment '序号',
           course_name string comment '课程名称',
           material_name string comment '教材名称',
           material_degree string comment '教材等级',
           author string comment '作者',
           publish_name string comment '出版社',
           publish_date string comment '版本及出版日期',
           apply_class string comment '适用班级',
           num string comment '数量'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_subscription_summary_sheet_2017_2018_02.csv
    }
#2017-2018学年第一学期征订汇总表（新生）
    function load_subscription_summary_sheet_2017_2018_01_new()
    {
        HIVE_DB=raw
        HIVE_TABLE=load_subscription_summary_sheet_2017_2018_01_new
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
           id string comment '序号',
           course_name string comment '课程名称',
           material_name string comment '教材名称',
           material_degree string comment '教材等级',
           author string comment '作者',
           publish_name string comment '出版社',
           publish_date string comment '版本及出版日期',
           apply_class string comment '适用班级',
           num string comment '数量'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_subscription_summary_sheet_2017_2018_01_new.csv
    }

#中省级以上优秀教材汇总表
    function load_excellent_teaching_materials_of_province(){
        HIVE_DB=raw
        HIVE_TABLE=load_excellent_teaching_materials_of_province
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
           id string comment '序号',
           materials_name string comment '教材名称',
           charge_person string comment '负责人',
           degree string comment '等级',
           time string comment '时间'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_excellent_teaching_materials_of_province.csv
    }

	#院级优秀教材汇总表
    function load_excellent_teaching_materials_of_college(){
        HIVE_DB=raw
        HIVE_TABLE=load_excellent_teaching_materials_of_college
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
           id string comment '序号',
           annual string comment '年度',
           materials_name string comment '教材名称',
           recommend_department string comment '推荐系部',
           editor_chief string comment '主编',
           editor_participate string comment '参编',
           award_level string comment '获奖级别',
           award_grade string comment '获奖等级（一等奖等）'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_excellent_teaching_materials_of_college.csv
    }

#校内实训基地数量
    function load_intramural_training_base(){
        HIVE_DB=raw
        HIVE_TABLE=load_intramural_training_base
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
           semester_year string comment '学年',
           semester string comment '学期',
		   annual string comment '年度',
           training_base_name string comment '实训基地名称',
           major_name string comment '适用专业',
		   department_name string comment '所属系部',
           setup_date string comment '成立时间',
           station_num string comment '工位数',
           device_price string comment '仪器设备值',
		   plan_divaricate_num string comment '计划开出实训项目数',
           reality_divaricate_num string comment '实际开出实训项目数',
           reality_period string comment '实训室实际使用课时'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_intramural_training_base.csv
    }
	
#校外实训基地数量
    function load_outside_training_base(){
        HIVE_DB=raw
        HIVE_TABLE=load_outside_training_base
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
           training_base_name string comment '实训基地名称',
           major_name string comment '适用专业',
		   department_name string comment '所属系部',
		   cooperator string comment '合作单位',
           setup_date string comment '成立时间',           
           validity_date string comment '有效截止时间'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_outside_training_base.csv
    }
	
#安保工作情况
    #反恐器械
    function load_security_situation(){
        HIVE_DB=raw
        HIVE_TABLE=load_security_situation
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
           name string comment '名称',
           price string comment '单价',
		   num string comment '数量',
		   purchase_date string comment '购买日期'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_security_situation.csv
    }
    #安保力量
    function load_security_power (){
        HIVE_DB=raw
        HIVE_TABLE=load_security_power
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            annual string comment '年度',
			person_count string comment '正式职工',
            protect_school_team string comment '护校队',
            security_company string comment '保安公司',
            flow_compilation string comment '流动编织',
            internal_insurance string comment '内保',
            input_person string comment '填报人',
            comment_person string comment '审核人'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_security_power.csv
    }
    #安保设施
    function load_security_facilities(){
        HIVE_DB=raw
        HIVE_TABLE=load_security_facilities
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            annual string comment '年度',
            fire_fighting_point string comment '消防点',
            monitoring_point string comment '监控点',
            security_facilities string comment '安保设施（如微型消防站）',
            other string comment '其他',
            other_things string comment '其他（防毒面具）',
            fire_suit string comment '消防服',
            input_person string comment '填报人',
            comment_person string comment '审核人'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_security_facilities.csv
    }

#近三年采购金额
    function load_purchase_amount_recent_three_year(){
        HIVE_DB=raw
        HIVE_TABLE=load_purchase_amount_recent_three_year
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
           year string comment '年度',
           name string comment '品名',
           january string comment '1月份',
           march string comment '3月份',
           april string comment '4月份',
           may string comment '5月份',
           june string comment '6月份',
           july string comment '7月份',
           september string comment '9月份',
           october string comment '10月份',
           november string comment '11月份',
           december string comment '12月份',
           summary string comment '合计'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_purchase_amount_recent_three_year.csv
    }

#来访交流数量
    function load_number_of_visits(){
        HIVE_DB=raw
        HIVE_TABLE=load_number_of_visits
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            visit_company_name string comment '来访交流单位名称',
            type string comment '类别',
            visit_aim string comment '来访目的',
            visit_time string comment '来访时间',
            visit_person string comment '来访人数',
            charge_person string comment '接待负责人',
            teacher_no string comment '工号',
            input_person string comment '填报人',
            check_person string comment '审核人'
         )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_number_of_visits.csv
    }
#实训教学
    function load_training_teaching(){
        HIVE_DB=raw
        HIVE_TABLE=load_training_teaching
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            grade string comment '年级',
            semester_year string comment '学年',
            semester string comment '学期',
            department_no string comment '系部编号',
            department_name string comment '系部名称',
            major_name string comment '专业名称',
            major_no string comment '专业编号',
            course_name string comment '课程名称',
            course_code string comment '课程代码',
            activity_num string comment '实际实训项目数',
            plan_activity_num string comment '计划开出项目数'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_training_teaching.csv
    }
#教学计划
    function load_teaching_plan(){
        HIVE_DB=raw
        HIVE_TABLE=load_teaching_plan
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            grade string comment '年级',
            semester_year string comment '学年',
            semester string comment '学期',
            course_code string comment '课程编号',
            course_name string comment '课程名称',
            department_no string comment '系部编号',
            department_name string comment '系部名称',
            major_no string comment '专业编号',
            major_name string comment '专业名称',
            class_no string comment '班级编号',
            class_name string comment '班级名称',
            teaching_book string comment '教案名称',
            teacher_no string comment '教案编写教师编号',
            teacher_name string comment '教案编写教师姓名',
            write_date string comment '教案编写时间'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_teaching_plan_01.csv
        load_data load_teaching_plan_02.csv

    }
#2017教材积分奖励发放
    function load_bonus_points_for_teaching_materials(){
        HIVE_DB=raw
        HIVE_TABLE=load_bonus_points_for_teaching_materials
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            post_time string comment '发放时间',
            salary_no string comment '工资号',
            name string comment '姓名',
            project_name string comment '项目名称',
            agent string comment '经办人',
            post_cash string comment '发放金额',
            post_reason string comment '发放事由',
            bank_card_no string comment '银行卡号'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_bonus_points_for_teaching_materials.csv
    }

#2018年1月份安保处夜间及双休日值班津贴
    function load_security_allowance(){
        HIVE_DB=raw
        HIVE_TABLE=load_security_allowance
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            post_time string comment '发放时间',
            salary_no string comment '工资号',
            name string comment '姓名',
            project_name string comment '项目名称',
            agent string comment '经办人',
            post_cash string comment '发放金额',
            post_reason string comment '发放事由',
            bank_card_no string comment '银行卡号'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_security_allowance.csv
    }

#校本教材情况统计
    function load_statistics_of_school_based_textbooks(){
        HIVE_DB=raw
        HIVE_TABLE=load_statistics_of_school_based_textbooks
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            id string comment '序号',
            material_name string comment '教材名称',
            editor string comment '主编',
            teacher_no string comment '教师工号',
            department_name string comment '系部',
            publish_name string comment '出版社',
            publish_time string comment '时间',
            publish_status string comment '出版情况'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_statistics_of_school_based_textbooks.csv
    }

#后勤人员
    function logistical_personnel(){
        HIVE_DB=raw
        HIVE_TABLE=logistical_personnel
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            year string comment '年度',
            tree string comment '园林',
            clear string comment '保洁',
            doctor string comment '医护',
            property string comment '物业',
            water_worker string comment '水工',
            electrician string comment '电工',
            comprehensive_maintenance string comment '综合维修',
            management string comment '管理人员',
            other string comment '其他'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data logistical_personnel.csv
    }
#参与建设实训基地名称
    function load_participation_in_the_construction_of_training_base_names(){
        HIVE_DB=raw
        HIVE_TABLE=load_participation_in_the_construction_of_training_base_names
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            teacher_name string comment '姓名',
            teacher_no string comment '工号',
            join_build_place_name string comment '参与建设实训基地名称',
            join_build_comment string comment '参与建设内容',
            build_start_date string comment '建设开始日期',
            build_end_date string comment '建设结束日期',
            charge_person string comment '负责人/参与人',
            input_person string comment '填报人',
            examine_person string comment '审核人',
            summary_person string comment '汇总人'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_participation_in_the_construction_of_training_base_names.csv
    }

#出国访学数量
    function load_number_of_students_studying_abroad(){
        HIVE_DB=raw
        HIVE_TABLE=load_number_of_students_studying_abroad
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            name string comment '姓名',
            no string comment '工号',
            project_name string comment '项目名称',
            visit_comment string comment '访学内容',
			visit_num string comment '访学组织编号',
            country_type string comment '国别',
            start_time string comment '开始时间',
			end_time string comment '结束时间',
            days_time string comment '时长（天）',
            input_person string comment '填报人',
            comment_person string comment '审核人'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_number_of_students_studying_abroad.csv
    }

#专任教师赴国外指导和开展培训情况
    function load_full_time_teachers_go_abroad_to_guide_and_carry_out_training(){
        HIVE_DB=raw
        HIVE_TABLE=load_full_time_teachers_go_abroad_to_guide_and_carry_out_training
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            carry_no string comment '培训编号',
			name string comment '姓名',
            no string comment '工号',
            carry_out_name string comment '培训名称',
            carry_out_comment string comment '培训内容',
            start_time string comment '开始时间',
			end_time string comment '开始时间',
            days_time string comment '时长（天）',
            country_type string comment '国别',
			contract_amount string comment '合同额',
            input_person string comment '填报人',
            comment_person string comment '审核人'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_full_time_teachers_go_abroad_to_guide_and_carry_out_training.csv
    }

#合作交流情况
    function load_cooperation_and_exchange(){
        HIVE_DB=raw
        HIVE_TABLE=load_cooperation_and_exchange
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            annual string comment '年度',
            project_num string comment '国际合作交流项目数',
            activity_num string comment '国际合作交流活动数',
            input_person string comment '填报人',
            judge_person string comment '审核人'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_cooperation_and_exchange.csv

    }
#聘请外教情况
    function load_hiring_foreign_teachers(){
        HIVE_DB=raw
        HIVE_TABLE=load_hiring_foreign_teachers
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            teacher_no string comment '工号',
            teacher_name string comment '外教姓名',
            country string comment '国籍',
            type string comment '类别',
            begin_time_and_end_time string comment '任教起止时间',
            input_person string comment '填报人',
            judge_person string comment '审核人'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_hiring_foreign_teachers.csv
    }

#数据采集Excel表 - 铁成（创新）学院
    #9.1合作企业数量
    function load_number_of_cooperative_enterprises_nine_point_one(){
        HIVE_DB=raw
        HIVE_TABLE=load_number_of_cooperative_enterprises_nine_point_one
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            company_no string comment '企业编号',
            cooperate_book_no string comment '合作合同编号',
            company_name string comment '企业名称',
            company_type string comment '企业类别',
            cooperate_comment string comment '合作内容',
            cooperate_major string comment '合作专业',
            cooperate_start_time string comment '合作开始时间',
            cooperate_end_time string comment '合作结束日期',
            next_time string comment '下个时间节点'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_number_of_cooperative_enterprises_nine_point_one.csv
    }
    #11.2社会培训情况
    function load_social_training_eleven_point_two(){
        HIVE_DB=raw
        HIVE_TABLE=load_social_training_eleven_point_two
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            teacher_name string comment '姓名',
            teacher_no string comment '工号',
            project_name string comment '项目名称',
            is_charge string comment '是否是负责人',
            start_and_end_time string comment '起止时间',
            days string comment '时长（天）',
            company_name string comment '培训对象（企业名称）',
            training_person_num string comment '培训人数',
            cooperate_book_money string comment '合同额（万元）',
            input_person string comment '填报人',
            judge_person string comment '审核人'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_social_training_eleven_point_two.csv
    }
    #1专业基本情况
    function load_basic_professional_situation_one(){
        HIVE_DB=raw
        HIVE_TABLE=load_basic_professional_situation_one
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            no string comment '序号',
            semester_year string comment '学年',
            grade string comment '年级',
            major_code string comment '专业代码',
            major_name string comment '专业名称',
            major_set_time string comment '专业设置时间',
            major_build_basic string comment '专业建设基础',
            major_build_aim string comment '专业建设目标',
            input_person string comment '填报人',
            judge_person string comment '审核人',
            comment_person string comment '汇总人'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_basic_professional_situation_one.csv
    }
    #1建设基础、建设目标
    function load_building_foundation_and_construction_goal(){
        HIVE_DB=raw
        HIVE_TABLE=load_building_foundation_and_construction_goal
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            semester_year string comment '学年',
            semester string comment '学期',
            grade string comment '年',
            course_name string comment '课程名称',
            course_code string comment '课程代码',
            build_basic string comment '建设基础（暂不填写）',
            build_aim string comment '建设目标（国家级/省级/院级精品在线开放课/教改课程）',
            aim_finish_time string comment '目标完成时间',
            input_person string comment '填报人',
            judge_person string comment '审核人',
            comment_person string comment '汇总人'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_building_foundation_and_construction_goal.csv
    }
    #2.1课程标准
    function load_curriculum_standards_two_point_one(){
        HIVE_DB=raw
        HIVE_TABLE=load_curriculum_standards_two_point_one
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            semester_year string comment '学年',
            semester string comment '学期',
            grade string comment '年级',
            course_name string comment '课程名称',
            course_code string comment '课程代码',
            major_name string comment '专业',
            course_comment string comment '课程标准内容(word文档)',
            change_time string comment '修订时间',
            apply_major string comment '适用专业',
            input_person string comment '填报人',
            judge_person string comment '审核人',
            comment_person string comment '汇总人'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_curriculum_standards_two_point_one.csv
    }
    #2.2授课计划
    function load_teaching_plan_two_point_two(){
        HIVE_DB=raw
        HIVE_TABLE=load_teaching_plan_two_point_two
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            semester_year string comment '学年',
            semester string comment '学期',
            grade string comment '年级',
            course_name string comment '课程名称',
            course_code string comment '课程代码',
            major_name string comment '专业',
            teaching_plan string comment '授课计划(word文档）',
            apply_major_name string comment '适用班级',
            teacher_name string comment '授课教师姓名',
            teacher_no string comment '授课教师工号',
            input_person string comment '填报人',
            judge_person string comment '审核人',
            comment_person string comment '汇总人'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_teaching_plan_two_point_two.csv
    }
    #2教学资源
    function load_teaching_resources_two(){
        HIVE_DB=raw
        HIVE_TABLE=load_teaching_resources_two
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            semester_year string comment '学年',
            semester string comment '学期',
            grade string comment '年级',
            course_name string comment '课程名称',
            course_code string comment '课程代码',
            open_department_name string comment '开课部门',
            apply_major_name string comment '适用专业(专业名称)',
            apply_major_code string comment '适用专业(对应专业代码)',
            charge_person string comment '课程负责人',
            teaching_book string comment '教案（暂不统计）',
            book_num string comment '文本数量',
            picture_num string comment '图像数量',
            course_num string comment '微课数量',
            music_and_movie_num string comment '音视频数量',
            multi_media_num string comment '多媒体课件数量',
            test_questions string comment '试题数',
            other_quantities_num string comment '其他的数量',
            input_person string comment '填报人',
            judge_person string comment '审核人',
            comment_person string comment '汇总人'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_teaching_resources_two.csv
    }
    #3.2.1参与专业建设情况
    function load_participation_in_professional_development_three_ponit_two_point_one(){
        HIVE_DB=raw
        HIVE_TABLE=load_participation_in_professional_development_three_ponit_two_point_one
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            name string comment '姓名',
            no string comment '工号',
            join_build_major_name string comment '参与建设专业名称',
            join_build_comment string comment '参与建设内容',
            build_start_time string comment '建设开始日期',
            build_end_time string comment '建设结束日期',
            input_person string comment '填报人',
            judge_person string comment '审核人',
            comment_person string comment '汇总人'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_participation_in_professional_development_three_ponit_two_point_one.csv
    }
    #3.2.2参与建设课程
    function load_participation_in_the_construction_course_three_point_two_point_two(){
        HIVE_DB=raw
        HIVE_TABLE=load_participation_in_the_construction_course_three_point_two_point_two
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            name string comment '姓名',
            no string comment '工号',
            join_build_course_name string comment '参与建设课程名称',
            join_build_comment string comment '参与建设内容',
            build_start_time string comment '建设开始日期',
            build_end_time string comment '建设结束时间',
            input_person string comment '填报人',
            judge_person string comment '审核人',
            comment_person string comment '汇总人'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_participation_in_the_construction_course_three_point_two_point_two.csv
    }
#课程教材选用情况一览表20180806175514
    function load_list_of_course_materials_selection(){
        HIVE_DB=raw
        HIVE_TABLE=load_list_of_course_materials_selection
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
           course_no string comment '课程号',
           course_name string comment '课程名称',
           open_department_name string comment '开课学院',
           class_info string comment '班级信息',
           class_person_num string comment '班级人数',
           course_type string comment '课程属性',
           teacher_name string comment '任课教师',
           book_name string comment '教材名称',
           standard_book_number string comment '标准书号',
           press string comment '出版社',
           author string comment '编者',
           layout string comment '版次',
           publish_time string comment '出版时间',
           price string comment '单价',
           evaluation_mark string comment '评优标识'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_list_of_course_materials_selection.csv
    }
#7-教职工社会兼职情况（截至2018-9）
    function load_part_time_job_in_teaching_staff(){
        HIVE_DB=raw
        HIVE_TABLE=load_part_time_job_in_teaching_staff
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            id string comment '序号',
            department_name string comment '所在部门',
            teacher_no string comment '教工号',
            teacher_name string comment '姓名',
            duty string comment '兼职职务',
            duty_begin_time string comment '兼职开始时间',
            duty_end_time string comment '兼职结束时间'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_part_time_job_in_teaching_staff.csv
    }
#8-教职工职（执业）资格证汇总表（2018-9）的副本
    function load_summary_of_teaching_staff_qualification_certificate(){
        HIVE_DB=raw
        HIVE_TABLE=load_summary_of_teaching_staff_qualification_certificate
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            id string comment '序号',
            department_name string comment '所属系部',
            name string comment '姓名',
            card_name string comment '资格证名称',
            gain_time string comment '获取时间'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_summary_of_teaching_staff_qualification_certificate.csv
    }

#历年学历学位提升名单（截至2018-9）
    function load_upgrading_of_academic_degrees(){
        HIVE_DB=raw
        HIVE_TABLE=load_upgrading_of_academic_degrees
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            id string comment '序号',
            basic_id string comment '基础编号',
            department_name string comment '部门',
            name string comment '姓名',
            high_academic_degrees string comment '最高学历',
            high_academic_school string comment '最高学位',
            belong_course string comment '所属学科',
            high_school_end_time string comment '最高学历毕（肄、结）业时间'

        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_upgrading_of_academic_degrees.csv
    }
#陕铁院 教职工企业实践汇总表（2007-2018.9.2）
    #企业实践(实践时间无法处理，所以没有办法编写脚本)
    function load_enterprise_practice(){
        HIVE_DB=raw
        HIVE_TABLE=load_enterprise_practice
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            id string comment '序号',
            name string comment '姓 名',
            department_name string comment '所在系部',
            act_company string comment '实践单位',
            act_time string comment '实践时间',
            time_judge string comment '时间认定',
            now_duty string comment '现职称',
            study_major string comment '所学专业',
            cooking_major string comment '从事专业',
            act_place string comment '实践地点',
            act_post string comment '实践岗位',
            note string comment '备注',
            exercise_type string comment '锻炼类型'

        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_enterprise_practice.csv
    }

    #挂职锻炼
    function load_hang_up_exercise(){
        HIVE_DB=raw
        HIVE_TABLE=load_hang_up_exercise
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            id string comment '序号',
            name string comment '姓名',
            time string comment '时间',
            place string comment '地点'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_hang_up_exercise.csv
    }

    #基础课部____课程标准__定稿__01
    function load_basic_curriculum_standard_finalized_01(){
        HIVE_DB=raw
        HIVE_TABLE=load_basic_curriculum_standard_finalized_01
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            semester_year string comment '学年',
            semester string comment '学期',
            grade string comment '年级',
            course_name string comment '课程名称',
            course_code string comment '课程代码',
            major_name string comment '专业',
            course_basic_comment string comment '课程标准内容（word文档）',
            update_time string comment '修订时间',
            apply_major string comment '适用专业',
            input_person string comment '填报人',
            judge_person string comment '审核人',
            comment_person string comment '汇总人'

        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_basic_curriculum_standard_finalized_01.csv
    }
#基础课部____授课计划__定稿__02
    function load_basic_curriculum_standard_finalized_02(){
        HIVE_DB=raw
        HIVE_TABLE=load_basic_curriculum_standard_finalized_02
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            semester_year string comment '学年',
            semester string comment '学期',
            grade string comment '年级',
            course_name string comment '课程名称',
            course_code string comment '课程代码',
            major_name string comment '专业',
            course_basic_comment string comment '课程标准内容（word文档）',
            update_time string comment '修订时间',
            apply_major string comment '适用专业',
            input_person string comment '填报人',
            judge_person string comment '审核人',
            comment_person string comment '汇总人'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_basic_curriculum_standard_finalized_02.csv
    }
#基础课部____授课教案__定稿__03
    function load_basic_curriculum_standard_finalized_03(){
        HIVE_DB=raw
        HIVE_TABLE=load_basic_curriculum_standard_finalized_03
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            semester_year string comment '学年',
            semester string comment '学期',
            grade string comment '年级',
            course_name string comment '课程名称',
            course_code string comment '课程代码',
            major_name string comment '专业',
            course_basic_comment string comment '课程标准内容（word文档）',
            update_time string comment '修订时间',
            apply_major string comment '适用专业',
            input_person string comment '填报人',
            judge_person string comment '审核人',
            comment_person string comment '汇总人'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_basic_curriculum_standard_finalized_03.csv
    }
#2017出版教材类 - 最终
    #出版教材类
    function load_publishing_textbooks(){
        HIVE_DB=raw
        HIVE_TABLE=load_publishing_textbooks
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            id string comment '序号',
            teacher_no string comment '工号',
            charge_person string comment '负责人 （参与人）',
            name string comment '名称',
            charge_person_department_name string comment '负责人（参与人）所在部门',
            book_name string comment '刊名（课题来源、颁奖）单位',
            set_time string comment '立项（到款、获奖、论文发表）时间',
            count_type string comment '计分类别',
            charge_person_position string comment '负责人（参与人）职称',
            order_person string comment '排名（署名）顺序',
            note string comment '备注',
            count_grade string comment '计分'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_publishing_textbooks.csv
    }
    #出版教材类奖励
    function load_publishing_materials_award(){
        HIVE_DB=raw
        HIVE_TABLE=load_publishing_materials_award
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            id string comment '序号',
            teacher_no string comment '工号',
            charge_person_name string comment '负责人 （参与人）',
            name string comment '名称',
            charge_person_department_name string comment '负责人（参与人）所在部门',
            book_name string comment '刊名（课题来源、颁奖）单位',
            set_time string comment '立项（到款、获奖、论文发表）时间',
            count_type string comment '计分类别',
            charge_person_level string comment '负责人（参与人）职称',
            order_name string comment '排名（署名）顺序',
            note string comment '备注',
            count_grade string comment '计分',
            courage_money string comment '奖励金额'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_publishing_materials_award.csv
    }
#副本2016年科研、教学、教研计分统计表(最终）
    #科研（科技处）
    function load_science_and_technology_division(){
        HIVE_DB=raw
        HIVE_TABLE=load_science_and_technology_division
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            id string comment '序号',
            teacher_no string comment '工号',
            charge_person string comment '负责人 （参与人）',
            name string comment '名称',
            charge_person_department string comment '负责人（参与人）所在部门',
            book_name string comment '刊名（课题来源、颁奖）单位',
            set_time string comment '立项（到款、获奖、论文发表）时间',
            count_type string comment '计分类别',
            charge_person_level string comment '负责人（参与人）职称',
            order_name string comment '排名（署名）顺序',
            note string comment '备注',
            count_grade string comment '计分',
            note_two string comment '备注'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_science_and_technology_division.csv
    }
    #教研（高教研究所）
    function load_teaching_and_research(){
        HIVE_DB=raw
        HIVE_TABLE=load_teaching_and_research
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            id string comment '序号',
            teacher_no string comment '工号',
            charge_person string comment '负责人 （参与人）',
            name string comment '名称',
            charge_person_department string comment '负责人（参与人）所在部门',
            set_department string comment '课题来源（颁奖）单位',
            set_time string comment ' 立项（到款、获奖）时间',
            count_type string comment '计分类别',
            charge_person_level string comment '负责人（参与人）职称',
            order_name string comment '排名（署名）顺序',
            note string comment '备注',
            count_grade string comment '计分'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_teaching_and_research.csv
    }
    #教科研（教务处）
    function load_teaching_and_research_dean_s_office(){
        HIVE_DB=raw
        HIVE_TABLE=load_teaching_and_research_dean_s_office
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            id string comment '序号',
            teacher_no string comment '工号',
            charge_person string comment '负责人 （参与人）',
            name string comment '名称',
            charge_person_department string comment '负责人（参与人）所在部门',
            set_department string comment '课题来源（颁奖）单位',
            set_time string comment ' 立项（到款、获奖）时间',
            count_type string comment '计分类别',
            charge_person_level string comment '负责人（参与人）职称',
            order_name string comment '排名（署名）顺序',
            note string comment '备注',
            count_grade string comment '计分',
            note_two string comment '备注2'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_teaching_and_research_dean_s_office.csv
    }
	
#习讯云老师指导任务情况统计
    function load_xi_xun_yun_teacher_guidance(){
        HIVE_DB=raw
        HIVE_TABLE=load_xi_xun_yun_teacher_guidance
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            teacher_name string comment '姓名',
            week_rate string comment '周签到率',
            week_submit string comment '周报提交率',
            week_mark string comment '周报批阅率',
            month_submit string comment '月报提交率',
            month_mark string comment '月报批阅率',
            whole_rate string comment '整体完成情况率'            
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_xi_xun_yun_teacher_guidance.csv
    }

#习讯云签到信息
    function load_xi_xun_yun_sign_info(){
        HIVE_DB=raw
        HIVE_TABLE=load_xi_xun_yun_sign_info
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            user_id String comment '用户编号',
            user_name String comment '姓名',
            number String comment '学号',
            portrait String comment '肖像',
            telephone String comment '联系电话',
            address String comment '签到地点',
            time String comment '签到时间',
            file String comment '文件',
            academy_id String comment '学院id',
            department_id String comment '系部id',
            major_id String comment '专业id',
            class_id String comment '班级id',
            entrance_year String comment '入学年份',
            graduate_year String comment '毕业年份',
            internship_address String comment '实习地址',
            company_name String comment '实习企业',
            company_address String comment '企业地址',
            academy_name String comment '学院名称',
            department_name String comment '系部名称',
            major_name String comment '专业名称',
            class_name String comment '班级名称'
        )
        partitioned by(date string comment '日期')
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        for file in `ls ${SHELL_PATH}/file/xi_xun_yun_sign/`
        do
            hive -e "load data local inpath '${SHELL_PATH}/file/xi_xun_yun_sign/$file' into table ${HIVE_DB}.${HIVE_TABLE} partition(date='${file:19:10}')"
        done
        # hive -e "LOAD DATA LOCAL INPATH '${SHELL_PATH}/file/xi_xun_yun_sign/*.txt' INTO TABLE ${HIVE_DB}.${HIVE_TABLE};"

    }
	
#习讯云实习分布情况
    function load_xi_xun_yun_internship_distribute(){
        HIVE_DB=raw
        HIVE_TABLE=load_xi_xun_yun_internship_distribute
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            enroll_year String comment '入学年份',
            area String comment '实习地区',
            number String comment '实习人数',
            num_rate String comment '占比'            
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        hive -e "LOAD DATA LOCAL INPATH '${SHELL_PATH}/file/xi_xun_yun/internship/internship_distribute.txt' INTO TABLE ${HIVE_DB}.${HIVE_TABLE};"

    }
	
#实习企业
    function load_xi_xun_yun_internship_company(){
        HIVE_DB=raw
        HIVE_TABLE=load_xi_xun_yun_internship_company
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            enroll_year String comment '入学年份',
            total_num String comment '总人数',
            enterprise_name String comment '企业名称',
            internship_num String comment '实习中人数',
            internship_rate String comment '占比'           
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        hive -e "LOAD DATA LOCAL INPATH '${SHELL_PATH}/file/xi_xun_yun/internship/internship_company.txt' INTO TABLE ${HIVE_DB}.${HIVE_TABLE};"

    }
	
#实习周报，月报批阅
    function load_internship_week_month_report(){
        HIVE_DB=raw
        HIVE_TABLE=load_internship_week_month_report
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            enroll_year String comment '入学年份',
            graduate_year String comment '毕业年份',
            submit_date String comment '提交时间日期',
            major_name String comment '专业名称',
            student_no String comment '学号',
            report_type String comment '报告类型（周报 WEEK  月报 MONTH）',
            mark_type String comment '批阅状态（已批阅 YPY  未批阅WPY）'           
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        hive -e "LOAD DATA LOCAL INPATH '${SHELL_PATH}/file/xi_xun_yun/internship/Internship_week_month_report.txt' INTO TABLE ${HIVE_DB}.${HIVE_TABLE};"

    }
	
#专业代码6位对应4位
    function load_major_matching(){
        HIVE_DB=raw
        HIVE_TABLE=load_major_matching
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            major_former_name string comment '旧专业名称',
            major_code string comment '6位专业代码',
            major_no string comment '4位专业代码',
            major_name string comment '新专业名称'    
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_major_matching.csv
    }
	
#专业排序简称表
    function load_major_brief_info(){
        HIVE_DB=raw
        HIVE_TABLE=load_major_brief_info
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            major_sort string comment '序号',
            department_name string comment '系部名称',
            department_no string comment '系部编号',
            major_name string comment '专业全称',
            major_brief string comment '专业简称',
            annual_system string comment '年制',
            note string comment '备注',
            major_no string comment '6位专业代码'           
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_major_brief_info.csv
    }
	
#系部排序简称表
    function load_department_brief_info(){
        HIVE_DB=raw
        HIVE_TABLE=load_department_brief_info
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
            department_sort string comment '序号',
            department_name string comment '系部全称',
            department_no string comment '系部编号',
            department_brief string comment '系部简称'           
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_department_brief_info.csv
    }

#合作企业订单培养人数2（黄老师提供的）
    function load_enterprise_cultivate_new(){
        HIVE_DB=raw
        HIVE_TABLE=load_enterprise_cultivate_new
        delete_table
        hive -e"
        CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
              annual String COMMENT '年度 格式  yyyy',
              student_name String COMMENT '学生姓名',
              student_no String COMMENT '学号',
              major String COMMENT '专业',
              major_no string comment '专业代码',
              enterprise_name String COMMENT '企业名称',
              cultivate_type String COMMENT '培养类别 订单培养人数 DDPY 现代学徒制培养  XDXTZPY 企业新型学徒制培养 QYXXXTPY 其他联合培养 QT',
              class_name String COMMENT '订单班名称',
              sponsorship_name String COMMENT '冠名名称',
              start_date String COMMENT '培养开始时间  格式  yyyymmdd',
              end_date String COMMENT '培养结束时间  格式 yyyymmdd',
              is_employed String COMMENT '是否录用   是YES  否NO',
              create_time String COMMENT '创建时间  create_time格式 yyyymmDDhhmmss'
        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
        LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_enterprise_cultivate_new.csv
    }

#教师属性表
function load_teacher_properties(){
    HIVE_DB=raw
    HIVE_TABLE=load_teacher_properties
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            id string comment '序号',
            teacher_no string comment '教师编号',
            teacher_property string comment '教师属性'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_data load_teacher_properties.csv
}


#夜不归宿表
function load_sleep_overs(){
    HIVE_DB=raw
    HIVE_TABLE=load_sleep_overs
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            student_no string COMMENT '学号',
            student_name string COMMENT '学生姓名',
            violate_type string COMMENT '违纪类型',
            semester_year string comment '学年',
            semester string comment '学期',
            violate_time string comment '违纪时间',
            violate_reason string comment '违纪原因'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_data load_sleep_overs.csv
}


#学生宿舍表
function load_student_dormitory(){
    HIVE_DB=raw
    HIVE_TABLE=load_student_dormitory
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            student_no string COMMENT '学号',
            student_name string COMMENT '学生姓名',
            dormitory_no string comment '宿舍号'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_data load_student_dormitory.csv
}

#宿舍卫生通报表
function load_dormitory_health(){
    HIVE_DB=raw
    HIVE_TABLE=load_dormitory_health
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            dormitory_no string comment '宿舍号',
            semester_year string comment '学年',
            semester string comment '学期',
            reason string comment '通报原因'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_data load_dormitory_health.csv
}

#勤工助学表
function load_student_work_study_info(){
    HIVE_DB=raw
    HIVE_TABLE=load_student_work_study_info
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            student_no String comment'学号',
            student_name String comment'姓名',
            id_card String COMMENT '身份证号',
            semester String	comment '学期',
            semester_year String comment '学年',
            start_time String comment '勤工助学开始日期',
            duration String comment '勤工助学时长',
            content String comment '勤工助学内容'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_data load_student_work_study_info.csv
}


#学生综合素质详情表
function load_quality_details(){
    HIVE_DB=raw
    HIVE_TABLE=load_quality_details
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            semester_year string comment '学年',
            semester string	comment '学期',
            student_no string COMMENT '学号',
            major_no string COMMENT '专业编号',
            class_no string COMMENT '班级编号',
            thought_score string COMMENT '思想素质',
            political_score string COMMENT '政治素质',
            morality_score string COMMENT '道德素质',
            study_attitude_score string COMMENT '学习态度',
            major_ability_score string COMMENT '专业技能',
            study_score string COMMENT '学习成绩',
            healthy_test_score string COMMENT '体质健康',
            psy_score string COMMENT '心理素质',
            developing_score string COMMENT '发展性素质',
            moral_score string COMMENT '思想道德素质',
            science_score string COMMENT '科学文化素质',
            mentality_score string COMMENT '身体心理素质',
            basic_score string COMMENT '基础性素质',
            general_score string COMMENT '综合素质'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_data load_quality_details.csv
}

#贷款信息（2016-2017,2017-2018,2018-2019）
function student_loan_info(){

    HIVE_DB=raw
    HIVE_TABLE=excel_student_loan_info
    delete_table

    hive -e "CREATE EXTERNAL TABLE IF NOT EXISTS ${HIVE_DB}.${HIVE_TABLE}(
          id STRING COMMENT '序号',
          semester_year STRING COMMENT '学年',
          student_name STRING COMMENT '学生姓名',
          id_card STRING COMMENT '身份证号',
          load_times STRING COMMENT '贷款次数',
          enter_date STRING COMMENT '入学年份',
          graduation_date  STRING COMMENT '毕业日期',
          department_name STRING COMMENT '院系',
          major_name STRING COMMENT '专业',
          amount STRING COMMENT '合同金额'
      )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
    LOCATION '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

    fn_log "create table ${HIVE_TABLE}"

    load_data  student_loan_info.csv
}

#4陕西铁路工程职业技术学院近三年就业情况
function load_employment_situation_of_shaanxi_railway_institute_in_recent_three_years(){
    HIVE_DB=raw
    HIVE_TABLE=load_employment_situation_of_shaanxi_railway_institute_in_recent_three_years
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            student_no string comment '学号',
            student_name string comment '姓名',
            employment_unit string comment '就业单位',
            whether_or_not_employment string comment '是否就业（是，否）',
            is_the_specialty_appropriate string comment '专业是否对口（是，否）',
            half_year_satisfaction string comment '入职半年满意度（百分比）',
            graduate_year string comment '毕业年份'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_data load_employment_situation_of_shaanxi_railway_institute_in_recent_three_years_2016.csv
    load_data load_employment_situation_of_shaanxi_railway_institute_in_recent_three_years_2017.csv
    load_data load_employment_situation_of_shaanxi_railway_institute_in_recent_three_years_2018.csv
}

#实习学生表
function load_intern_student_info(){
   HIVE_DB=raw
   HIVE_TABLE=load_intern_student_info
   delete_table
   hive -e "
    create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
        student_no string comment '学号',
        student_name string comment '姓名',
        admission_year string comment '入学年份',
        graduate_year string comment '毕业年份',
        sex string comment '性别',
        department_name string comment '系部',
        major_name string comment '专业名称',
        class_name string comment '班级名称',
        first_passed_time string comment '第一次办理通过时间',
        recent_passed_time string comment '最近办理通过时间',
        point string comment '积分',
        point_rank string comment '积分排名',
        arrival_time string comment '到岗时间',
        resignation string comment '辞职时间',
        intern_status string comment '实习状态',
        intern_enterprise_name string comment '实习单位',
        intern_enterprise_no string comment '组织机构代码',
        intern_enterprise_property string comment '实习单位性质',
        intern_enterprise_position string comment '实习岗位',
        salary string comment '薪资待遇',
        intern_address string comment '实习地址',
        mobile_phone_number string comment '联系方式',
        email string comment '邮箱地址',
        head_teacher string comment '班主任',
        instructor string comment '指导老师',
        enterprise_teacher string comment '企业老师',
        enterprise_teacher_phone string comment '企业老师电话',
        emergency_contact string comment '紧急联系人',
        emergency_contach_phone string comment '紧急联系人电话',
        intern_protocol string comment '实习协议',
        is_recycle string comment '是否回收',
        accommodation_type string comment '住宿方式',
        inschool_accommodation_address string comment '校内住宿地址',
        outschool_accommodation_address string comment '校外住宿地址',
        is_school_arrangement string comment '学校安排',
        join_high_education_progression_counseling string comment '参加高职升学辅导',
        bad_record string comment '不良记录',
        health_status string comment '身心健康'
    )row format delimited fields terminated by ','
    location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
   " 

   load_data load_intern_student_info_2014.csv
   load_data load_intern_student_info_2015.csv
   load_data load_intern_student_info_2016.csv
}

#省份信息表
function load_province_list(){
    HIVE_DB=raw
    HIVE_TABLE=load_province_list
    delete_table
    hive -e "
        create external table if not exists  ${HIVE_DB}.${HIVE_TABLE}(
            province_name string comment '省份名称'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_data load_province_list.csv
}

#教学计分表
function load_teaching_and_research_score(){
    HIVE_DB=raw
    HIVE_TABLE=load_teaching_and_research_score
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            id string comment '序号',
            teacher_no string comment '序号',
            teacher_name string comment '负责(参与)人',
            research_name string comment '名称',
            department_name string comment '负责人(参与人)所在部门',
            book_department_name string comment '刊名单位',
            start_date string comment '立项时间',
            score_type string comment '计分类别',
            teacher_professional_title string comment '负责人(参与人)职称',
            order string comment '排名（署名）顺序',
            note string comment '备注',
            score string comment '计分'
        )
        partitioned by (year string comment '文件年份')
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    hive -e "load data local inpath '${SHELL_PATH}/file/load_teaching_and_research_score_2016.csv' into table ${HIVE_DB}.${HIVE_TABLE} partition(year='2016')"
    hive -e "load data local inpath '${SHELL_PATH}/file/load_teaching_and_research_score_2017.csv' into table ${HIVE_DB}.${HIVE_TABLE} partition(year='2017')"
}

#教研计分表
function load_teaching_and_research_teaching_score(){
    HIVE_DB=raw
    HIVE_TABLE=load_teaching_and_research_teaching_score
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            id string comment '序号',
            teacher_no string comment '号',
            teacher_name string comment '负责(参与)人',
            research_name string comment '名称',
            department_name string comment '负责人(参与人)所在部门',
            book_department_name string comment '课题来源单位',
            start_date string comment '立项时间',
            score_type string comment '计分类别',
            teacher_professional_title string comment '负责人(参与人)职称',
            order string comment '排名（署名）顺序',
            note string comment '备注',
            score string comment '计分'
        )
        partitioned by (year string comment '文件年份')
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    hive -e "load data local inpath '${SHELL_PATH}/file/load_teaching_and_research_teaching_score_2015.csv' into table ${HIVE_DB}.${HIVE_TABLE} partition(year='2015')"
    hive -e "load data local inpath '${SHELL_PATH}/file/load_teaching_and_research_teaching_score_2016.csv' into table ${HIVE_DB}.${HIVE_TABLE} partition(year='2016')"
    hive -e "load data local inpath '${SHELL_PATH}/file/load_teaching_and_research_teaching_score_2017.csv' into table ${HIVE_DB}.${HIVE_TABLE} partition(year='2017')"
}

#年度优秀
function load_teacher_ndyx_score(){
    HIVE_DB=raw
    HIVE_TABLE=load_teacher_ndyx_score
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
        id string comment '序号',
        teacher_name string comment '教师姓名',
        youxiu_excellent string comment '优秀',
        annual string comment '年度'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
     load_data load_teacher_ndyx_score.csv
}
#优秀教师
function load_teacher_yxjs_score(){
    HIVE_DB=raw
    HIVE_TABLE=load_teacher_yxjs_score
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
        id string comment '序号',
        teacher_name string comment '教师姓名',
        youxiu_excellent string comment '优秀',
        annual string comment '年度'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
     load_data load_teacher_yxjs_score.csv
}
#先进个人
function load_teacher_xjgr_score(){
    HIVE_DB=raw
    HIVE_TABLE=load_teacher_xjgr_score
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
        id string comment '序号',
        teacher_name string comment '教师姓名',
        youxiu_excellent string comment '优秀',
        annual string comment '年度'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
     load_data load_teacher_xjgr_score.csv
}
#师德
function load_teacher_sd_score(){
    HIVE_DB=raw
    HIVE_TABLE=load_teacher_sd_score
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
        id string comment '序号',
        teacher_name string comment '教师姓名',
        youxiu_excellent string comment '优秀',
        annual string comment '年度'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
     load_data load_teacher_sd_score.csv
}

#课程建设基础目标
function load_course_construction_base_target(){
    HIVE_DB=raw
    HIVE_TABLE=load_course_construction_base_target
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            semester_year string comment '学年',
            semester string comment '学期',
            year string comment '年份',
            course_name string comment '课程名称',
            course_code string comment '课程代码',
            construction_base string comment '建设基础',
            construction_target string comment '建设目标',
            target_accomplish string comment '目标完成时间'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_data load_course_construction_base_target.csv
}

#20181027党建党费收支情况
    function load_revenue_and_expenditure_of_party_construction_20181027(){
        HIVE_DB=raw
        HIVE_TABLE=load_revenue_and_expenditure_of_party_construction_20181027
        delete_table
        hive -e "
            create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
                annual string comment '年度',
                income string comment '收入',
                cost string comment '支出'
            )
            row format delimited fields terminated by ','
            location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_revenue_and_expenditure_of_party_construction_20181027.csv
    }

#近五年来入党积极分子与发展对象和预备党员的比例变化情况
    function load_proportion_of_activists_who_joined_the_party_probationary_party_members(){
        HIVE_DB=raw
        HIVE_TABLE=load_proportion_of_activists_who_joined_the_party_probationary_party_members
        delete_table
        hive -e "
            create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
                annual string comment '年度',
                number_of_activists_joining_the_party string comment '入党积极分子数量',
                number_of_development_objects string comment '发展对象数量',
                number_of_probationary_party_members string comment '预备党员数量',
                proportion_of_party_activists_and_probationary_party_members string comment '入党积极分子与预备党员比例'
            )
            row format delimited fields terminated by ','
            location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_proportion_of_activists_who_joined_the_party_probationary_party_members.csv
    }
#师生党员队伍数量情况
    function load_number_of_student_party_members(){
        HIVE_DB=raw
        HIVE_TABLE=load_number_of_student_party_members
        delete_table
        hive -e "
            create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
                annual string comment '年度',
                teacher_department_num string comment '教师党员数量',
                student_department_num string comment '学生党员数量',
                student_and_teacher_num string comment '师生党员数量'
            )
            row format delimited fields terminated by ','
            location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_number_of_student_party_members.csv
    }
#师生党员占比情况
    function load_proportion_of_teachers_and_students(){
        HIVE_DB=raw
        HIVE_TABLE=load_proportion_of_teachers_and_students
        delete_table
        hive -e "
            create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
                annual string comment '年度',
                teacher_department_radio string comment '教师党员占比',
                student_department_radio string comment '学生党员占比',
                teacher_and_student_radio string comment '师生党员占比'
            )
            row format delimited fields terminated by ','
            location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_proportion_of_teachers_and_students.csv
    }
#师生数量情况
    function load_quantity_of_teachers_and_students(){
        HIVE_DB=raw
        HIVE_TABLE=load_quantity_of_teachers_and_students
        delete_table
        hive -e "
            create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
                annual string comment '年度',
                teacher_num string comment '教师数量',
                student_num string comment '学生数量',
                teacher_and_student_num string comment '师生数量'
            )
            row format delimited fields terminated by ','
            location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_quantity_of_teachers_and_students.csv
    }
	
#学生就业去向表
function load_employment_2016(){
    HIVE_DB=raw
    HIVE_TABLE=load_employment_2016
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            student_no string comment '学号',
            student_name string comment '姓名',
            employment_unit string comment '就业单位',
            whether_or_not_employment string comment '是否就业（是，否）',
            is_the_specialty_appropriate string comment '专业是否对口（是，否）',
            half_year_satisfaction string comment '入职半年满意度（百分比）'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_data load_employment_2016.csv
}

#学生就业去向表
function load_employment_2017(){
    HIVE_DB=raw
    HIVE_TABLE=load_employment_2017
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            student_no string comment '学号',
            student_name string comment '姓名',
            employment_unit string comment '就业单位',
            whether_or_not_employment string comment '是否就业（是，否）',
            is_the_specialty_appropriate string comment '专业是否对口（是，否）',
            half_year_satisfaction string comment '入职半年满意度（百分比）'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_data load_employment_2017.csv
}

#学生就业去向表
function load_employment_2018(){
    HIVE_DB=raw
    HIVE_TABLE=load_employment_2018
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            student_no string comment '学号',
            student_name string comment '姓名',
            employment_unit string comment '就业单位',
            whether_or_not_employment string comment '是否就业（是，否）',
            is_the_specialty_appropriate string comment '专业是否对口（是，否）',
            half_year_satisfaction string comment '入职半年满意度（百分比）'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_data load_employment_2018.csv
}

#课程实训项目信息
function load_course_training_project_info(){
    HIVE_DB=raw
    HIVE_TABLE=load_course_training_project_info
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            semester_year string comment '学年',
            semester string comment '学期',
            grade string comment '年级',
            course_name string comment '课程名称',
            course_code string comment '课程代码',
            department_name string comment '系部名称',
            training_project_name string comment '实训项目名称',
            training_base string comment '实训项目所属实训基地(室)名称',
            target_hours string comment '实训项目计划课时',
            actual_hours string comment '实际项目实际开出课时'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    load_data load_course_training_project_info_2015_2016_1.csv
    load_data load_course_training_project_info_2015_2016_2.csv
    load_data load_course_training_project_info_2016_2017_1.csv
    load_data load_course_training_project_info_2016_2017_2.csv
    load_data load_course_training_project_info_2017_2018_1.csv
    load_data load_course_training_project_info_2017_2018_2.csv
}

#合作企业接受顶岗实习人数信息
function load_cooperated_enterprise_intern_student_num(){
    HIVE_DB=raw
    HIVE_TABLE=load_cooperated_enterprise_intern_student_num
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            major_code string comment '专业编号',
            major_name string comment '专业名称',
            intern_num string comment '顶岗实习人数'
        )
        partitioned by (year string comment '年份')
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    hive -e "load data local inpath '${SHELL_PATH}/file/load_cooperated_enterprise_intern_student_num_2017.csv' into table ${HIVE_DB}.${HIVE_TABLE} partition(year='2017')"
    hive -e "load data local inpath '${SHELL_PATH}/file/load_cooperated_enterprise_intern_student_num_2016.csv' into table ${HIVE_DB}.${HIVE_TABLE} partition(year='2016')"
    hive -e "load data local inpath '${SHELL_PATH}/file/load_cooperated_enterprise_intern_student_num_2018.csv' into table ${HIVE_DB}.${HIVE_TABLE} partition(year='2018')"
    
}



#2018年录取数据和报道数据
function load_admission_data_and_reporting_data(){
    HIVE_DB=raw
    HIVE_TABLE=load_admission_data_and_reporting_data
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            province string comment '省份',
            exam_id string comment '考生号',
            is_register string comment '是否报道',
            pass_exam_id string comment '准考证号',
            name string comment '姓名',
            sex string comment '性别',
            born_date string comment '出生年月',
            political_category string comment '政治面貌',
            nation string comment '民族',
            exam_category string comment '考生类别',
            graduate_type string comment '毕业类别',
            school_code string comment '中学代码',
            school_name string comment '中学名称',
            residence_number string comment '考生户口所在地区代码',
            residence_place string comment '考生户口所在地区',
            exam_student_where_come_from string comment '考生户口所在市',
            shanxi_three_big_place string comment '陕西三大地区',
            id_card string comment '身份证号',
            exam_student_id string comment '考生号(省招办)',
            address string comment '家庭地址',
            postal_code string comment '邮政编码',
            phone_num string comment '联系电话',
            receive string comment '收件人',
            batch string comment '批次',
            family string comment '科类',
            family_one string comment '科类1',
            plan_nature string comment '计划性质',
            push_exam_score string comment '投档成绩',
            professional_benchmarking_results string comment '专业投档基准成绩',
            voluntary_filing string comment '投档志愿',
            admin_major string comment '录取专业',
            department_name string comment '院系',
            school_place string comment '校区',
            admin_method string comment '录取方式',
            major_aim_exchange string comment '专业志愿调剂',
            chinese string comment '语文',
            math string comment '数学',
            foreign_language string comment '外语',
            mix_thing string comment '综合',
            report_book_num string comment '通知书编号'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

    load_data load_admission_data_and_reporting_data.csv
}

#餐饮满意度
function load_meal_assessment(){
    HIVE_DB=raw
    HIVE_TABLE=load_meal_assessment
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            annual string comment '年度 格式  yyyy',
            month string comment '月份   格式  mm',
            campus string comment '校区   临渭区  高新区',
            floor string comment '楼层',
            satisfaction string comment '满意度  好 GOOD 一般  GENERAL差  POOR'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_data load_meal_assessment.csv
}

#餐饮服务采购情况
function load_catering_purchase(){
    HIVE_DB=raw
    HIVE_TABLE=load_catering_purchase
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            annual string comment '年度 格式  yyyy',
            month string comment '月份 格式 ：1,2,3....12',
			purchase_date string COMMENT '采购时间 格式：yyyyMMdd ',
            campus string comment '校区 临渭校区 高新区',
            purchase_type string COMMENT '采购类型 米 RICE 面 FLOUR 油 COOKOIL ',
            purchase_amount string COMMENT '采购金额（元）'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_data load_catering_purchase.csv
}

#考生户口所在地区代码
function load_code_and_place_relation(){
    HIVE_DB=raw
    HIVE_TABLE=load_code_and_place_relation
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            code string comment '代码',
            place string comment '地区'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

    load_data load_code_and_place_relation.txt
}

#招生专业代码对应
function load_enrollment_code_format(){
    HIVE_DB=raw
    HIVE_TABLE=load_enrollment_code_format
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            major_name string comment '专业名称',
            major_code string comment '专业代码'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

    load_data load_enrollment_code_format.csv
}

#党组织建设
function load_party_organization_construction(){
        HIVE_DB=raw
        HIVE_TABLE=load_party_organization_construction
        delete_table
        hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            organization_no string comment '组织编号',
            organization_name string comment '组织名称',
            father_no string comment '上级编号',
            degree string comment '层级',
            organization_num string comment '组织人数'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_party_organization_construction.csv
}

#学院党建荣誉
function load_college_party_building_honor(){
        HIVE_DB=raw
        HIVE_TABLE=load_college_party_building_honor
        delete_table
        hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            annual string comment '年份',
            department_org_person string comment '党组织和人员',
            honor string comment '获奖荣誉'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_college_party_building_honor.csv
}

#2016-2018年学院“两优一先”表彰情况
function load_recognition_of_years_2016_2018(){
        HIVE_DB=raw
        HIVE_TABLE=load_recognition_of_years_2016_2018
        delete_table
        hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            person_and_department string comment '个人和部门',
            annual string comment '年度',
            earn_name string comment '获奖名称'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

        load_data load_recognition_of_years_2016_2018.csv
}

#国际交流合作信息
function load_international_communicate_info(){
    HIVE_DB=raw
    HIVE_TABLE=load_international_communicate_info
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            teacher_name string comment '教师姓名',
            teacher_no string comment '教师功耗',
            teacher_comein_year string comment '教师入职年份',
            project_start_end_time string comment '项目开始结束时间',
            project_country string comment '国家',
            project_unit string comment '合作交流单位',
            project_name string comment '项目名称'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_data load_international_communicate_info.csv
}

#国际交流合作项目金额信息
function load_international_communicate_project_money_info(){
    HIVE_DB=raw
    HIVE_TABLE=load_international_communicate_project_money_info
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            project_name string comment '项目名称',
            project_start_end_time string comment '项目开始结束时间',
            year string comment '年份',
            country string comment '国别',
            project_unit string comment '合作交流单位',
            people_num string comment '项目人数',
            leader string comment '项目领队人员姓名',
            money string comment '资金额（万）',
            who_pay_money string comment '出资方'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_data load_international_communicate_project_money_info.csv
}

#教师管理人员分类信息
function  load_teacher_manager_type_info(){
    HIVE_DB=raw
    HIVE_TABLE=load_teacher_manager_type_info
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            teacher_name string comment '教师姓名',
            teacher_no string comment '教师编号',
            manager_type string comment '管理人员分类',
            department string comment '部门'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_data load_teacher_manager_type_info.csv
}

#国家奖学金
function  load_national_scholarship(){
    HIVE_DB=raw
    HIVE_TABLE=load_national_scholarship
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            stu_name string comment '姓名',
            stu_no string comment '学号',
            level string comment '年制',
            department_name string comment '系部名称',
			annual string comment '年级',
            major_name string comment '专业名称',
            class_name string comment '班级',
            identity_card string comment '身份证号',
			province string comment '省份',
			type string comment '类型',
            scholarship_num string comment '奖金数',
            id string comment '编号',
            year string comment '年份',
            telephone string comment '联系电话'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_data load_national_scholarship.csv
}

#优秀学生，优秀学生干部奖金表
function load_good_student_worker_info(){
    HIVE_DB=raw
    HIVE_TABLE=load_good_student_worker_info
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            department_brief string comment '系部简称',
            class_name string comment '班级名称',
            student_name string comment '姓名',
            sex string comment '性别',
            scholarship string comment '奖学金',
            good_student_award string comment '优秀学生奖金',
            good_student_worker_award string comment '优秀学生干部奖金',
            total_award string comment '合计',
            student_identify_code string comment '身份证号码'
        )
        partitioned by (semester_year string comment '学年')
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    hive -e "load data local inpath '${SHELL_PATH}/file/load_good_student_worker_info_2015_2016_part1.csv' into table ${HIVE_DB}.${HIVE_TABLE} partition(semester_year='2015-2016')"
    hive -e "load data local inpath '${SHELL_PATH}/file/load_good_student_worker_info_2015_2016_part2.csv' into table ${HIVE_DB}.${HIVE_TABLE} partition(semester_year='2015-2016')"
    hive -e "load data local inpath '${SHELL_PATH}/file/load_good_student_worker_info_2016_2017.csv' into table ${HIVE_DB}.${HIVE_TABLE} partition(semester_year='2016-2017')"
    hive -e "load data local inpath '${SHELL_PATH}/file/load_good_student_worker_info_2017_2018.csv' into table ${HIVE_DB}.${HIVE_TABLE} partition(semester_year='2017-2018')"

}

#青春榜样学生信息
function load_youth_example_student_info(){
    HIVE_DB=raw
    HIVE_TABLE=load_youth_example_student_info
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            student_name string comment '学生姓名',
            class_name string comment '班级名称',
            student_code string comment '学生编号'
        )
        partitioned by (year string comment '年份')
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "
    hive -e "load data local inpath '${SHELL_PATH}/file/load_youth_example_student_info_2016.csv' into table ${HIVE_DB}.${HIVE_TABLE} partition(year='2016')"
    hive -e "load data local inpath '${SHELL_PATH}/file/load_youth_example_student_info_2017.csv' into table ${HIVE_DB}.${HIVE_TABLE} partition(year='2017')"

}

#校内技能大赛获奖名单
function load_inschool_skill_contest_info(){
    HIVE_DB=raw
    HIVE_TABLE=load_inschool_skill_contest_info
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            year string comment '年份',
            student_name string comment '学生姓名',
            class_name string comment '班级姓名',
            department_name string comment '系部名称',
            project_name string comment '项目名称',
            award string comment '奖项等级',
            student_no string comment '学号'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"

    load_data load_inschool_skill_contest_info.csv
}
#教师指导学生获奖信息
function load_teacher_student(){
    HIVE_DB=raw
    HIVE_TABLE=load_teacher_student
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
        student_no string comment '学号',
        student_name string comment '学生姓名',
        earn_name string comment '获奖名称',
        begin_date string comment '获奖日期',
        award_rank string comment '获奖等级',
        teacher_no_1 STRING COMMENT '教师编号1' ,
        teacher_name_1  STRING COMMENT '教师姓名1',
        teacher_no_2  STRING COMMENT '教师编号2' ,
        teacher_name_2  STRING COMMENT '教师姓名2',
        teacher_no_3  STRING COMMENT '教师编号3' ,
        teacher_name_3  STRING COMMENT '教师姓名3',
        teacher_no_4  STRING COMMENT '教师编号4' ,
        teacher_name_4  STRING COMMENT '教师姓名4',
        teacher_no_5  STRING COMMENT '教师编号5',
        teacher_name_5  STRING COMMENT '教师姓名5',
        award_type string comment '获奖类型'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'"
    load_data load_teacher_student.csv
}


#蓝墨云
function load_lanmoyun_academy(){
    HIVE_DB=raw
    HIVE_TABLE=load_lanmoyun_academy
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            department_no string comment '院系代码',
            department_name string comment '院系名称'
        )
        row format delimited fields terminated by '\t'
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_lanmoyun_data academy.txt
}

function load_lanmoyun_activity_lib(){
    HIVE_DB=raw
    HIVE_TABLE=load_lanmoyun_activity_lib
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(            
            course_name string comment '课程名称',
			department_name string comment '院系名称',
			activity_name string comment '课堂活动名称',
			activity_type string comment '课堂活动类型',
			class_name string comment '班级名称',
			class_no string comment '班级编号',
			creator_name string comment '创建人',
			create_time  string COMMENT '创建时间'
        )
        row format delimited fields terminated by '\t'
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_lanmoyun_data activity_lib.txt
}

function load_lanmoyun_attendance(){
    HIVE_DB=raw
    HIVE_TABLE=load_lanmoyun_attendance
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            course_no string comment '班课号',
            checkin_id string comment '登记编号',
			department_name string comment '院系名称',
			attendance_time string comment '登记时间',
			class_name string comment '班级名称',
			course_name string comment '课程名称',
			student_name string comment '学生名称'
        )
        row format delimited fields terminated by '\t'
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_lanmoyun_data attendance.txt
}

function load_lanmoyun_class(){
    HIVE_DB=raw
    HIVE_TABLE=load_lanmoyun_class
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            course_no string comment '班课号',
            department_name string comment '院系名称',
			semester_desc string comment '学期',
			class_name string comment '班级名称',
			course_name string comment '课程名称',
			teacher_name string comment '教师名称',
			class_type string comment '课程类型',
			create_time  string COMMENT '创建时间'
        )
        row format delimited fields terminated by '\t'
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_lanmoyun_data class.txt
}

function load_lanmoyun_questions_lib(){
    HIVE_DB=raw
    HIVE_TABLE=load_lanmoyun_questions_lib
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            questions_no string comment '试题编码',
            questions_type string comment '试题类型',
			score string comment '分值',
			difficulty_type string comment '难度类型',
			questions_desc string comment '试题内容',
			course_name string comment '课程名称',
			creator_name string comment '创建人',
			create_time  string COMMENT '创建时间'
        )
        row format delimited fields terminated by '\t'
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_lanmoyun_data questions_lib.txt
}

function load_lanmoyun_resource_lib(){
    HIVE_DB=raw
    HIVE_TABLE=load_lanmoyun_resource_lib
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            course_no string comment '班课号',
            department_name string comment '院系名称',
			resource_name string comment '资源库名称',
			class_name string comment '班级名称',
			course_name string comment '课程名称',
			creator_name string comment '创建人',
			create_time  string COMMENT '创建时间',
			view_num string comment '访问量'
        )
        row format delimited fields terminated by '\t'
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_lanmoyun_data resource_lib.txt
}

function load_lanmoyun_sign_detail(){
    HIVE_DB=raw
    HIVE_TABLE=load_lanmoyun_sign_detail
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            checkin_id string comment '登记编号',
            student_name string comment '学生名称',
			student_no string comment '学生代码',
			is_sign string comment '是否缺勤'
        )
        row format delimited fields terminated by '\t'
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_lanmoyun_data sign_detail.txt
}

function load_lanmoyun_student(){
    HIVE_DB=raw
    HIVE_TABLE=load_lanmoyun_student
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
			student_no string comment '学生代码',
			img string comment '图片',
            student_name string comment '学生名称',
            department_name string comment '院系名称',
			phone string comment '联系电话',
			xp string comment '经验值',			
			student_type string comment '学生类型'
        )
        row format delimited fields terminated by '\t'
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_lanmoyun_data student.txt
}

function load_lanmoyun_student_file(){
    HIVE_DB=raw
    HIVE_TABLE=load_lanmoyun_student_file
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            student_no string comment '学生代码',
            course_no string comment '班课号',
			xp string comment '经验值',
			create_time  string COMMENT '创建时间'
        )
        row format delimited fields terminated by '\t'
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_lanmoyun_data student_file.txt
}

function load_lanmoyun_teacher(){
    HIVE_DB=raw
    HIVE_TABLE=load_lanmoyun_teacher
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
		    teacher_name string comment '教师名称',			
            department_name string comment '院系名称',
            teacher_name2 string comment '教师名称2',
			phone_num string comment '手机号',
			create_time  string COMMENT '创建时间'
        )
        row format delimited fields terminated by '\t'
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_lanmoyun_data teacher.txt
}

function load_lanmoyun_teacher_file(){
    HIVE_DB=raw
    HIVE_TABLE=load_lanmoyun_teacher_file
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            file_no string comment '档案号',
            img string comment '图片',
			course_no string comment '班课号',
			view_num string comment '访问量',
			create_time  string COMMENT '创建时间'
        )
        row format delimited fields terminated by '\t'
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_lanmoyun_data teacher_file.txt
}

#各系专业介绍-教务处(1)
function load_professional_introduction(){
        HIVE_DB=raw
        HIVE_TABLE=load_professional_introduction
        delete_table
        hive -e "
            create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
                department_name string comment '院系',
                major_name string comment '专业',
                introduction string comment '介绍'
            )
            row format delimited fields terminated by ','
            location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
        "

        load_data load_professional_introduction.csv
}

#
function load_lanmoyun_data(){
    hive -e "LOAD DATA LOCAL INPATH '${LANMOYUN_PATH}/${1}' INTO TABLE ${HIVE_DB}.${HIVE_TABLE};"
    fn_log "LOAD DATA ${HIVE_TABLE}"
}

#学生校外获奖类型关键词枚举
function load_outschool_award_type_enum(){
    HIVE_DB=raw
    HIVE_TABLE=load_outschool_award_type_enum
    delete_table
    hive -e "
        create external table if not exists ${HIVE_DB}.${HIVE_TABLE}(
            award_type string comment '获奖类型',
            keyword string comment '匹配关键词'
        )
        row format delimited fields terminated by ','
        location '${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE}'
    "

    load_data load_outschool_award_type_enum.csv
}

#删除hive表
function load_data(){
    hive -e "LOAD DATA LOCAL INPATH '${SHELL_PATH}/file/${1}' INTO TABLE ${HIVE_DB}.${HIVE_TABLE};"
    fn_log "LOAD DATA ${HIVE_TABLE}"
}

#删除hive表
function delete_table(){
    hadoop fs -rm -r ${BASE_HIVE_DIR}/${HIVE_DB}/${HIVE_TABLE} || :
    hive -e "DROP TABLE IF EXISTS ${HIVE_DB}.${HIVE_TABLE};"
}

if [ $# == 1 ];
    then
    $($1)
else

##课程建设基础目标
#load_course_construction_base_target
##助学金信息()2017-2018
#    financial_aid_info_2017
##助学金信息(2016-2017)
#    financial_aid_info_2016
##贷款信息
#    loan_info
##学生勤工助学记录
#     load_work_study_info
##学生宿舍通报记录
#    circulate_info_info
##学生勤工助学对应岗位
#    load_work_location_info
##省份表
   load_province_info
##县级表
    load_county
##专业录取学生信息表
#    load_admissions_info
##职称对应表
#    load_zhicheng_info
##管理人员类型对应表
#    load_guanlirenyuan_info
##学校负债情况
#     load_school_property
##最近五年招生情况
#    #2017年考生信息
#    load_exam_student_infomation_2017
#    #2017年5年制考生信息
#    load_exam_student_infomation_201705
#    #2016年考生信息
#    load_exam_student_infomation_2016
#    #2015年考生信息
#    load_exam_student_infomation_2015
#    #2014年考生信息
#    load_exam_student_infomation_2014
#    #2013年考生信息
#    load_exam_student_infomation_2013
##学生党费缴纳情况
#   student_party_payment
##老师党费缴纳情况
#   teacher_party_payment
##本校主要指标拟合表1（基于2015届、2014届样本）
#    department_info_2016
##本校主要指标拟合表2（基于2015届、2014届样本）
#    major_info_2016
##陕西铁路工程职业技术学院原始数据（2015届短期）
#    graduate_student_info_2016
##陕西铁路工程职业技术学院调研原始数据(2015)
#    graduate_student_info_2015
##本校主要指标拟合表（基于2016届、2015届样本）
#    department_info_2017
##陕西铁路工程职业技术学院原始数据(2017)
#    graduate_student_info_2017
##党员数据
#    department_info
##党费收入支出信息表
#    department_income
##党建活动表2016
#    department_activity_2016
##党建活动表2017
#    department_activity_2017
##党建活动表2018
#    department_activity_2018
##帮扶数据(2012-2013学年“一对一”结对帮扶名单)
#    help_student_2012_2013
##帮扶数据(2013-2014学年“一对一”结对帮扶名单)
#    help_student_2013_2014
##帮扶数据(2014-2015学年“一对一”结对帮扶名单)
#    help_student_2014_2015
##帮扶数据(2015-2016学年“一对一”结对帮扶名单,临渭校区)
#    help_student_2015_2016_linwei
##帮扶数据(2015-2016学年“一对一”结对帮扶名单,高新校区)
#    help_student_2015_2016_gaoxin
##帮扶数据(2016-2017学年“一对一”结对帮扶名单(截止20161212))
#    help_student_2016_2017
##帮扶数据(2017-2018学年“一对一”结对帮扶名单（截至12月4日）)
#    help_student_2017_2018
##课堂教学分析
#    load_class_teaching_comment
##职教云头脑风暴
#    load_brainstorming
##2016-2018所有小区用电用水情况
#    load_electricity_water
##2016-今人员评价情况
#    load_valuation
##专业发展目标
#    load_major_develop_goal
##课程体系与教学运行
#    load_courses_education
##2014招生计划表
#    load_enrollment_plan_2014
##2015招生计划表
#    load_enrollment_plan_2015
##2016招生计划表
#    load_enrollment_plan_2016
##2017招生计划表
#    load_enrollment_plan_2017
##2018招生计划表
#    load_enrollment_plan_2018
##资产状况
#    load_asset_status
##学院层面资产状况
#    load_academa_asset_status
##兼职教师
#    load_pluralistic_teacher
##校内外兼职教师
#    load_all_pluralistic_teacher
##老师教学质量工程
#    load_quality_engineering
##课堂教学分析
#    load_class_teaching_comment
##职教云头脑风暴
#    load_brainstorming
##2016-2018所有小区用电用水情况
#    load_electricity_water
##2016-今人员评价情况
#    load_valuation
##专业发展目标
#    load_major_develop_goal
##课程体系与教学运行
#    load_courses_education
##2014招生计划表
#    load_enrollment_plan_2014
##2015招生计划表
#    load_enrollment_plan_2015
##2016招生计划表
#    load_enrollment_plan_2016
##2017招生计划表
#    load_enrollment_plan_2017
##2018招生计划表
#    load_enrollment_plan_2018
##资产状况
#    load_asset_status
##学院层面资产状况
#    load_academa_asset_status
##兼职教师
#    load_pluralistic_teacher
##校内外兼职教师
#    load_all_pluralistic_teacher
##报修信息表（2016年5月～2016年12月）
#    load_repair_info_2016_01
##报修信息表（2017年1月～2017年7月）
#    load_repair_info_2017_01
##报修信息表（2017年7月～2017年12月）
#    load_repair_info_2017_02
##报修信息表（2018年）
#    load_repair_info_2018_01
##是否毕业
#    load_is_graduate
##院办--扶贫情况
#    load_help_poor_person_obj
##媒体报道
#    load_media_coverage
##新媒体运营情况
#    load_new_media_operation
##新媒体排名
#    load_new_media_rankings
##校园网
#    load_web_site
##学院层面社会影响
#	load_society_influence
##2017-2018学年社团活动信息表
#	load_organization_member_activity
##2017-2018学年学生参加社团信息表
#    load_student_join_club
##团员团干信息统计
#    load_communist_youth_yeague_member
##督导听课
#    load_supervisor_attend
##蓝墨云资源库
#    load_resource_database
##合作企业
#    load_enterprise_cooperation
##社会培训
#    load_society_train
##函授情况
#    load_postal_tuition
##社区服务情况
#    load_community_services
##教材数量
#    load_quantity_teaching_materials
##校企合作
#    load_school_enterprise_cooperation
##校企合作文件情况-增加-校企合作处
#    load_school_enterprise_cooperation_documents
##学院层面—校友工作
#    #校友捐赠情况
#    load_alumni_work
#    #校友情况
#    load_alumni_situation
#    #校友会情况
#    load_alumni_association
#     #校友活动情况
#    load_alumni_activities
##教师层面数据汇总（2018.8.1)
#    #3.1.13教学事故
#    load_teaching_accident
#    #3.2.1参与专业建设情况（汇总）
#    load_participation_in_professional_construction
#    #3.2.2参与建设课程（汇总）
#    load_participate_in_the_construction_course
#    #3.2.3参与实训基地建设情况（汇总）
#    load_participate_in_the_construction_of_training_base
#    #3.4.5教学质量工程积分（教学科）
#    load_teaching_quality_engineering_integral
##1学院层面（开发课程与教材）
#    #校企合作共同开发教材
#    load_college_teaching_material
#    #课程
#    load_college_course
##近三年教学任务
#    #2015-2016-1
#    load_teaching_task_2015_2016_1
#    #2015-2016-2
#    load_teaching_task_2015_2016_2
#    #2016-2017-1
#    load_teaching_task_2016_2017_1
#    #2016-2017-2
#    load_teaching_task_2016_2017_2
#    #2017-2018-1
#    load_teaching_task_2017_2018_1
#    #2017-2018-2
#    load_teaching_task_2017_2018_2
##合作企业订单培养人数
#    load_enterprise_cultivate
##校内取证统计表
#    load_credential_statistics
##2015-2016奖学金获奖情况
#    load_scholarship_condition_2015_2016
##2016-2017奖学金获奖情况
#    load_scholarship_condition_2016_2017
##专业基本情况
#    load_professional_basic_situation
##专业目录情况
#    load_professional_catalogues
##捐赠设备情况
#    load_situation_of_donation_equipment
##资源库信息表
#    load_major_resource_pool_info
##课程改革信息
#	load_reform_course_info
##教学改革项目信息
#	load_reform_project_info
##科研成果获奖
#    load_award_winning_scientific_research_achievements
##精品在线开放课程
#    load_boutique_online_open_course
##教师归属
#    load_teacher_ownership
##系统库匹配国标专业代码
#    load_matching_major_code
##2015-2016(2)征订汇总表
#    load_subscription_summary_sheet_2015_2016_02
##2015-2016学年第一学期征订汇总表（老生）
#    load_subscription_summary_sheet_2015_2016_01
##2015-2016征订汇总表（新生）
#    load_subscription_summary_sheet_2015_2016_01_new
##2016-2017(2)征订汇总表
#    load_subscription_summary_sheet_2016_2017_02
##2016-2017学年第一学期征订汇总表（老生）
#    load_subscription_summary_sheet_2016_2017_01
##2016-2017学年第一学期征订汇总表（新生）
#    load_subscription_summary_sheet_2016_2017_01_new
##2017-2018(1)征订汇总表（老生）
#    load_subscription_summary_sheet_2017_2018_01
##2017-2018第二学期征订汇总表
#    load_subscription_summary_sheet_2017_2018_02
##2017-2018学年第一学期征订汇总表（新生）
#    load_subscription_summary_sheet_2017_2018_01_new
##中省级以上优秀教材汇总表
#    load_excellent_teaching_materials_of_province
##院级优秀教材汇总表
#    load_excellent_teaching_materials_of_college
##校内实训基地数量
#    load_intramural_training_base
##校外实训基地数量
#	load_outside_training_base
##安保工作情况
#    #反恐器械
#    load_security_situation
#    #安保力量
#    load_security_power
#    #安保设施
#    load_security_facilities
##近三年采购金额
#    load_purchase_amount_recent_three_year
##来访交流数量
#    load_number_of_visits
##实训教学
#    load_training_teaching
##教学计划
#    load_teaching_plan
##2017教材积分奖励发放
#    load_bonus_points_for_teaching_materials
##2018年1月份安保处夜间及双休日值班津贴
#    load_security_allowance
##校本教材情况统计
#    load_statistics_of_school_based_textbooks
##后勤人员
#    logistical_personnel
##参与建设实训基地名称
#    load_participation_in_the_construction_of_training_base_names
##出国访学数量
#    load_number_of_students_studying_abroad
##专任教师赴国外指导和开展培训情况
#    load_full_time_teachers_go_abroad_to_guide_and_carry_out_training
##合作交流情况
#    load_cooperation_and_exchange
##聘请外教情况
#    load_hiring_foreign_teachers
##数据采集Excel表 - 铁成（创新）学院
#    #9.1合作企业数量
#    load_number_of_cooperative_enterprises_nine_point_one
#    #11.2社会培训情况
#    load_social_training_eleven_point_two
#    #1专业基本情况
#    load_basic_professional_situation_one
#    #1建设基础、建设目标
#    load_building_foundation_and_construction_goal
#    #2.1课程标准
#    load_curriculum_standards_two_point_one
#    #2.2授课计划
#    load_teaching_plan_two_point_two
#    #2教学资源
#    load_teaching_resources_two
#    #3.2.1参与专业建设情况
#    load_participation_in_professional_development_three_ponit_two_point_one
#    #3.2.2参与建设课程
#    load_participation_in_the_construction_course_three_point_two_point_two
#
##课程教材选用情况一览表20180806175514
#    load_list_of_course_materials_selection
#
##7-教职工社会兼职情况（截至2018-9）
#    load_part_time_job_in_teaching_staff
##8-教职工职（执业）资格证汇总表（2018-9）的副本
#    load_summary_of_teaching_staff_qualification_certificate
##历年学历学位提升名单（截至2018-9）
#    load_upgrading_of_academic_degrees
##陕铁院 教职工企业实践汇总表（2007-2018.9.2）
#    #企业实践
#    load_enterprise_practice
#    #挂职锻炼
#    load_hang_up_exercise
#
##基础课部____课程标准__定稿__01
#    load_basic_curriculum_standard_finalized_01
##基础课部____授课计划__定稿__02
#    load_basic_curriculum_standard_finalized_02
##基础课部____授课教案__定稿__03
#    load_basic_curriculum_standard_finalized_03
#
##2017出版教材类 - 最终
#    #出版教材类
#    load_publishing_textbooks
#    #出版教材类奖励
#    load_publishing_materials_award
##副本2016年科研、教学、教研计分统计表(最终）
#    #科研（科技处）
#    load_science_and_technology_division
#    #教研（高教研究所）
#    load_teaching_and_research
#    #教科研（教务处）
#    load_teaching_and_research_dean_s_office
##习讯云签到信息
#    load_xi_xun_yun_sign_info
##专业代码6位对应4位
#    load_major_matching
##习讯云老师指导任务情况统计
#    load_xi_xun_yun_teacher_guidance
##习讯云实习分布情况
#    load_xi_xun_yun_internship_distribute
##实习企业
#    load_xi_xun_yun_internship_company
##实习周报，月报批阅
#    load_internship_week_month_report
##专业排序简称表
#    load_major_brief_info
##系部排序简称表
#    load_department_brief_info
##合作企业订单培养人数2（黄老师提供的）
#    load_enterprise_cultivate_new
##教师属性表
#    load_teacher_properties
##夜不归宿表
#    load_sleep_overs
##学生宿舍表
#    load_student_dormitory
##宿舍卫生通报表
#    load_dormitory_health
##勤工助学表
#    load_student_work_study_info
##学生综合素质详情表
#    load_quality_details
##贷款信息（2016-2017,2017-2018,2018-2019）
#    student_loan_info
##实习学生表
#    load_intern_student_info
##省份信息表
#    load_province_list
##4陕西铁路工程职业技术学院近三年就业情况
#    load_employment_situation_of_shaanxi_railway_institute_in_recent_three_years
##教科研成果计分表
#    load_teaching_and_research_score
##年度优秀
#    load_teacher_ndyx_score
##优秀教师
#    load_teacher_yxjs_score
##优秀个人
#    load_teacher_xjgr_score
##优秀师德
#    load_teacher_sd_score
##20181027党建党费收支情况
#    load_revenue_and_expenditure_of_party_construction_20181027
##近五年来入党积极分子与发展对象和预备党员的比例变化情况
#    load_proportion_of_activists_who_joined_the_party_probationary_party_members
##师生党员队伍数量情况
#    load_number_of_student_party_members
##师生党员占比情况
#    load_proportion_of_teachers_and_students
##师生数量情况
#    load_quantity_of_teachers_and_students
##学生就业去向表
#    load_employment_2016
##2018年录取数据和报道数据
#    load_admission_data_and_reporting_data
##餐饮满意度
#    load_meal_assessment
##考生户口所在地区代码
#    load_code_and_place_relation
##招生专业代码对应
#    load_enrollment_code_format
##党组织建设
#    load_party_organization_construction
##学院党建荣誉
#    load_college_party_building_honor
##2016-2018年学院“两优一先”表彰情况
#    load_recognition_of_years_2016_2018
##各系专业介绍-教务处(1)
#    load_professional_introduction
	
#爬取蓝墨云数据
#	load_lanmoyun_academy
#	load_lanmoyun_activity_lib
#	load_lanmoyun_attendance
#	load_lanmoyun_class
#	load_lanmoyun_questions_lib
#	load_lanmoyun_resource_lib
#	load_lanmoyun_sign_detail
#	load_lanmoyun_student
#	load_lanmoyun_student_file
#	load_lanmoyun_teacher
#	load_lanmoyun_teacher_file
	
fi